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.

No comments:

Post a Comment