There is a wonderful free program from sqldts.com, I recommend it. Or
you can save each dts to it's own file by using the save as in the
design of the packages. Otherwise you will need to restore the master DB
to retrieve all of your jobs and DTS packs. Not an easy task or possibly
not the right one for your situation.

Hope this helps.
Rob

-----Original Message-----
From: nguyen [mailto:[Email Address Removed]
Sent: Wednesday, February 26, 2003 2:26 PM
To: LazyDBA.com Discussion
Subject: Moving local packages to new server

Hello Gurus,

We've moved databases to a new server. The problem is I don't know how
to
move the local packages, which are scheduled to run at specific times on
a
daily basis, to the new server. I looked over past emails from other
people
in this list. I see a few that suggested using DTS, but I don't see
instructions on how to do this. If possible, would someone let me know
how
I can move these packages over?

Thank you for your help.



---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page