The easiest way is to open the package in design mode, and then save it to
the new server.

Of course I only had to move about 20 packages when we build the new server!

Hope this helps.

Tom

-----Original Message-----
From: [Email Address Removed] Wednesday, February 26, 2003 3: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