Legacy DTS packages

[lalitha1]

Hi,

We are doing side by side migartion from SQL server 2000 to SQl server 2005. We have 50 DTS packages. Can someone tell me how to move all these DTS packaes to SSIS environment and put them under Management studio > Legacy > Data Transformation Services.

I would like to rewrite them later but for now want to move all of them under Legacy folder. Appreciate your help.

Thanks

 

[DatabasePrincess]

What I did was follow the instructions in the link below. I used the data pump task to copy the packages from msdb.dbo.sysdtspackages to the same table in the other server.

http://www.sqldts.com/204.aspx

It worked great for me. Hope this helps!

 

[lalitha1]

Thanks. My 2000 DTS packages even after I moved them under Legacy (into sql 2005) still point to serverA (old server), now that I have to change them so that they point to serverB (new server). Is there any easiest way to do this or do I have to open each and every DTS and then point them to new server and then save them under Legacy. Again appreciate all your help.

 

[DatabasePrincess]

I have yet to find a way to change the connections other than opening each one and changing it. Sorry. :-(

 

[lalitha1]

After I installed the SQL server 2000 DTS designer components on new server where i have sql 2005 and where i have all the DTS under legacy, when I try to open DTS it gives me error saying that "the DTS host failed to load or save the package properly" ANy help please.