sql 2000 DTS task in sql 2005

#1

I've used sql 2000 DTS to copy objects (tables, views, stored procedures)
from one database to another without problem. In sql 2005, I can copy tables
and views without problems via the available wizard.
I've been trying to find the sql 2005 wizard that can copy objects other
than tables and views -- like stored procedures -- to another database.
Can't find it anywhere!

Any help is very much appreciated.

#2

Hello Wolverine,

It is no longer in the Import/Export wizard but it is in the Proper BIDs
designer. Have you looked there? (Transfer SQL Server Objects Task)

Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

Quote:

I've used sql 2000 DTS to copy objects (tables, views, stored
procedures)
from one database to another without problem. In sql 2005, I can copy
tables
and views without problems via the available wizard.
I've been trying to find the sql 2005 wizard that can copy objects
other
than tables and views -- like stored procedures -- to another
database.
Can't find it anywhere!
Any help is very much appreciated.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

sql 2000 DTS task in sql 2005

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

sql 2000 DTS task in sql 2005 - 04-01-2006 , 07:16 PM

Re: sql 2000 DTS task in sql 2005 - 04-03-2006 , 03:48 PM