|
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')
|