SQL Server Performance Forum – Threads Archive
Generate a SQL Script to Create DTS Packages?Heya ppol! Kinda new here with DTS…I got a Local Package in DTS that copies data from one database into another from two different servers… I need to know if there is a way to sort of make an SQL Script that I can run to be able to generate a working copy of that Local Package on a newly created server… or If you know any other way to backup Local Packages in DTS in a way that it will point to the newly created server instead of the old one… Thx lots for any reply!
You can not create sql script for DTS.
Open DTS in designer and save as meta data storage file.
This file you copy to your new server.
And then open that .dts file and restore your dts in new SQL server.
Chnage the connection properties in DTS and thats it.