Copying DTS Packages

[wbodger]

Is there any nice way to copy a group of DTS Packages from one server to another? Like from the production server to a reporting server? Both SQL Server Enterprise Edition, SP4.

WB

 

[mrdenny]

You can either backup and restore the msdb database, or you can open them and resave them to the new destination one at a time.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

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

http://www.mrdenny.com

 

[wbodger]

Ha! I did not realize I could save them between 2 servers that way, thank you very much.

WB