SQLUSA

Microsoft SQL Server 2000

Best Practices

 

How to transfer DTS packages between servers?

 

The simplest way is "save as" from the DTS designer.

You can also use a simple DataPump (transform data) task to transfer the contents of sysdtspackages directly between servers.

To see the content of a package, execute in msdb:

SELECT * FROM dbo.sysdtspackages
WHERE [name] = ('DTSPackage1')

 

Best in the World in SQL Server Training
 
SQLUSA.com Home Page