Copy DTS packages | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Copy DTS packages

Hi, how can I copy DTS packages from Sql 7.0 to Sql 2000? Zsolt
You 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