I use DtsBackup 2000 which is a free download here http://www.sqldts.com/.
I actually use it to backup all my packages through task scheduler

-----Original Message-----
From: Sanchez Anthony F
[mailto:mssqldba-ezmlmshield-x11471783.[Email address protected]
Sent: Monday, August 30, 2004 10:47 AM
To: LazyDBA Discussion
Subject: Moving DTS Packages...

Question,



Using the DTS transfer wizard, can I set msdb as the source and
destination databases and "select * from sysdtspackages" on the source?
My goal is to transfer DTS packages from one machine to another machine,
BOTH SQL Server 2000 boxes.



Are there better practices for this purpose? Can I accomplish this task
through a script?



Thanks!



Anthony.



---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]

MS Sql Server LazyDBA home page