import dts package from another sql server instance

[OhioSteve]

We have two db servers, each with its own instance of SQL Server. They are "test1" and "production1". I don't administer either server, but I use them both. Now, I have developed a brilliant dts package in test1. How do I bring it into production1? I understand that all of the objects that I mention in the package must exist in the new db. But how do I bring it over?

 

[mrdenny]

Use Enterprise Manager and connect to the Test Instance. Open your DTS package.
At the top Click Package
Click Save Ass.
In the server field, type in the name of the Production server.

Done.


Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(Not quite so old any more.)

 

[OhioSteve]

Okay, I did what you said and the "save as..." command appeared, and the production server WAS a valid destination. Cool! I can't do the actual operation because I'm not done yet (writing the package). I will update you when I try to move it!

 

[JayKusch]

You could also save the DTS package out to a Structure Storage File, a *.dts file, on a floppy or a share on the originating server.

Then open the DTS designer on the Production machine and open the *.dts file there. Once it is in place, save it again but this time as a SQL Server package on the Production server.

Thanks

J. Kusch