Cannot copy indexes w 2005 Import/Export Wizard

In SQL 2000, the 'Copy SQL Server Objects' task allows 'copy indexes' under
'Advanced Copy Options' when transferring tables. But I cannot see where the
SQL 2005 Import and Export Wizard allows this option. Is there an easy way
to do this (I hope) ?
Hello Mark,
You could check "Transfer SQL server objects" task in SSIS project in
VS.net 2005. DTS is ugpraded to SSIS in SQL 2005.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>Thread-Topic: Cannot copy indexes w 2005 Import/Export Wizard
>thread-index: AcYnif7U0qKGdOuRRFuiyisljvKhWg==
>X-WBNR-Posting-Host: 67.96.43.11
>From: "=?Utf-8?B?TWFya0dzY2g=?=" <markgsch@.noemail.noemail>
>Subject: Cannot copy indexes w 2005 Import/Export Wizard
>Date: Wed, 1 Feb 2006 15:48:26 -0800
>Lines: 4
>Message-ID: <D1072BA0-E4FF-4E06-8F4C-018F334730F9@.microsoft.com>
>MIME-Version: 1.0
>Content-Type: text/plain;
>charset="Utf-8"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>Content-Class: urn:content-classes:message
>Importance: normal
>Priority: normal
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
>Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFT NGXA03.phx.gbl
>Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.server:419786
>X-Tomcat-NG: microsoft.public.sqlserver.server
>In SQL 2000, the 'Copy SQL Server Objects' task allows 'copy indexes'
under
>'Advanced Copy Options' when transferring tables. But I cannot see where
the
>SQL 2005 Import and Export Wizard allows this option. Is there an easy
way
>to do this (I hope) ?
>