How to Transfer a DTS package from one server to another?

[Andel]

I would like to transfer a DTS package from my production environment to test environment. I tried saving it to a Structured Storage File format but when I open the file in my test environment, it screws up the transformation because the server names are different. When i change the server name to the correct server name, it deletes the table already set up.

Is there any other way other than designing this package again manually?

Thanks in advance!

Andel
andel@barroga.net

http://www.iluko.com

 

[john76]

Check out DTSBackup 2000 from SQLDTS.Com

http://www.sqldts.com/default.aspx?242

It's free and works great for me to move packages from dev/test to production.

HTH,
John