sql server dts: 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

[quoted text, click to view]

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

--

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@discussions.microsoft.com> wrote in
message news:964EECF5-DF3A-4389-950F-26A3C563E30F@microsoft.com...
[quoted text, click to view]