Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 Scheduling Legacy DTS 2000 in sql 2005

Author  Topic 

svicky9
Posting Yak Master

232 Posts

Posted - 2007-09-07 : 06:20:45
Hi Guys

There are a few dts packages in our sql server 2000 database which we schedule daily for at night for business purposes.

how can i schedule the same DTS packages in Legacy SQL 2000 DTS when we migrate the Databases across to Sql 2005.

Can that be done or we need to migrate the DTS Package to SSIS

Vic

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-09-07 : 23:38:52
You can migrate dts packages to sql2k5 with wizard and run them as scheduled job.
Go to Top of Page
   

- Advertisement -