Hello,
How do I move the DTS packages I've created on my developing server to the test server in the best way?

I don't find the way to do it and I have hard to believe that I would have to build them from scratch first on the test server and then again on the production server.

Thanks in advance

//Matte

Use save as, then save it point it to the new server location

Jaime E. Maccou
Applications Analyst

If the DTS is quite complex, preserving the layout could be
very important.
You could also need to move many DTS.
The best solution I know is the free tool DTSBackup 2000
avalaible at http://www.sqldts.com/default.aspx?242

Manuel Fabris

You can use the Structured Storage File option in the Package-> Save As.. Location menu.

DTS packages in the form of Structured Storage file (packagename.dts) is very easy to maintain across multiple servers.