Move DTS Packages between servers

[johnherman]

Anyone know of an easy way to move (many!) DTS packages from one server to another server?

thanks.

Sometimes the grass is greener on the other side because there is more manure there - original.

 

[nigelrivett]

Where are they held.
If you save them as files then it's just a matter of copying the file.

You can copy the contents of msdb..sysdtspackages if that's where you are holding them.

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

 

[esdee]

or just use Darren Green's DTSBackup 2000
from SQLDTS.com