SQL Server Performance Forum – Threads Archive
Copy DTS packages
Hi, how can I copy DTS packages from Sql 7.0 to Sql 2000? ZsoltYou can copy or move MSDB using COPY DATABASE WIZARD, but make sure to modify sql connection properties if sql server name changed. Otherwise,open DTS package in design view in EM and save as .dts file. Open dts file in new SQL machine Enterprise Manager and save as to the local SQL Server. HTH Satya SKJ
]]>