the easiest way to transfer DTS packages is with bcp, not only works with 2000 but also will move to 2005 as well.
Recover Those Packages!
Ever need to recover a single package? Don't have local backups? Read this!!!
2001-08-16
6,853 reads
Move DTS packages to another server
on production EXEC master.dbo.xp_cmdshell "bcp msdb.dbo.sysdtspackages out f:\DRTEST\DTS_Packages.txt -c" on DR EXEC master.dbo.xp_cmdshell "bcp msdb.dbo.sysdtspackages in f:\DRTest\DTS_Packages.txt -c -E -T"
Related content
Save Your Packages Locally
DBAs often ask how to transfer DTS packages and move them between servers. They also want a version control system that is more robust than that provided in msdb. Steve Jones looks at one of the features of the DTS designer that solves both of these problems.
2001-08-09
5,928 reads
Scrubbing Data With DTS : Part 1
When trying to implement data from an external source, very rarely do you receive the data in perfect condition. In part one of this series, we show you how to clean your data using DTS.
2001-06-01
8,402 reads
Using FileSystemObject with DTS
This article will show you how to use the FileSystemObject to determine the existence of a file inside DTS.
2001-05-23
8,323 reads
Using the Dynamic Properties Task
In SQL Server 7.0 Data Transformation Services (DTS), dynamically configuring packages was difficult. With the aid of a new Dynamic Properties task in SQL Server 2000, this assignment is easy.
2001-05-18
12,197 reads