Showing posts with label purchased. Show all posts
Showing posts with label purchased. Show all posts

Wednesday, March 7, 2012

Move DTS packages from SQL 2000 to SQL 2005

We have purchased a new Development SQL Server that is running SQL Server 2005. Our existing Development SQL Server is running SQL 2000.

How can I move the DTS packages from the SQL 2000 server to the new SQL 2005 server? I will be upgrading them to SSIS at some point, but don't have the time now.

thanks

sql server 2005 has a package migration wizard that might work for you.