The instructions i sent previously give you the ability to customize your
transfers by creating a dts package that transfers the contents of the
msdb.sysdtspackages table. Rob is correct in saying that the tool he
mentions is the easiest way to transfer packages in bulk to or from any of
the acceptable formats.

One correction though...the restore mentioned involves the msdb database.

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


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] 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] 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