Printable View
Hi,
I have to migrate from sql server 2000 to sql server 2005 and have to transfer all database. This database contain some DTS packages and I have to transfer these DTS packages there.
How can I do that one, I know SSIS, but I want to remain it as DTS packages as I donot want to chane its properties in 2005 server
Depending on number of DTS packages you have you can use different options.
If number is low you can open each and save it in new server. You must install backward compatibility module separately in SQL 2005 to view these packages.
For large number of packages, you can transfer data from sysdtspackages to corresponding table in SQL 2005.