I'm seeking help on system backup for DTS packages, and, information on how
to backup or save DTS packages so they can be moved / restored to another
server. (we can save to individual .dts files but this is longwinded - we're
looking for a batch solution)

We have tried backup of the msdb and restoring elsewhere but the DTS
packages do not appear after restore. What are we doing wrong?

Many TIA

Stephen

Stephen Lonsdale wrote:
Hi Stephen,
have you tried "DTSBackup 2000"?
http://www.sqldts.com/default.aspx?242

--
David

Yon can develop a simple vbscript to do that
do a query on the system table that store the list of the dts and do a save
of each package

to restore them do a simple script that scan a folder and load each dts
package in a specified server
This solution is more powerful than dtsbackup2000 because you can script the
udl to use on the new server for example.



"Stephen Lonsdale" <Stephen Lonsdale (AT) discussions (DOT) microsoft.com> wrote in
message news:964EECF5-DF3A-4389-950F-26A3C563E30F (AT) microsoft (DOT) com...