Moving DTS Packages | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Moving DTS Packages

Hello! I have an old NT server running SQL7 and its running out of space. We’re building out a test server and putting SQL2K on it. The old server has 190 DTS packages on it. Is there anyway I can move the DTS packages at one time rather than going one package at a time? Thank you for your assistance. Rinu
http://vyaskn.tripod.com/sql_server_dts_best_practices.htm – more said here.
MSDB is the key system database to restore DTS packages including jobs/. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>