DTSBackup 2000 is a designed to help with both backup and transfer of DTS package. This version of DTSBackup provides full support for Microsoft SQL Server 2000. New features introduced in this version of DTSBackup include a new DTSBackup file format and direct transfer of packages between SQL Servers. These methods do not suffer the loss of layout information encountered when using the DTS object model.
For further information and download the tool just visit this link.
Beside DTS (Data Transformation Services) tool, there is SSIS (SQL Server Integration Services) tool also. Just visit this link.
 This tool has helped me to transfer thousand DTS package when there is a request from developer to get DTS from production and put it into development. After relocate, just check all the package make sure there isn’t information of production environment such as server name, user and password in development. |
