Promoting DTS pacakages

Environment: SQL Server 2000

I have made a few DTS packages (in testing environment). Now I have to promote them to production environment. Whats the best way to do this? One of the ways I can think of is save the DTS packages in visual basic format and go through the VB code and check for any dependent variables etc. But once a DTS packages is saved as VB code it cant be saved back as a package. So how would you use the DTS package (in VB code) on SQL Server 2000.Open the package in Design.

Click Package, Save As...

Select the server you would like to save the package to.

Open it on the new server and check for dependencies.

That's all there is to it.|||Hi!

For transferring a DTS-Package from one Server to another or for Backup purposes I use a little free tool called "DTSBackup 2000". You can find the description and the download link on the following page (http://www.sqldts.com/?242).

Hope that makes it easier!
Greetings,
Carsten|||Originally posted by CarstenK
Hi!

For transferring a DTS-Package from one Server to another or for Backup purposes I use a little free tool called "DTSBackup 2000". You can find the description and the download link on the following page (http://www.sqldts.com/?242).

Hope that makes it easier!
Greetings,
Carsten

Thanks, the software helped me out.