Open the DTS package and chose Save As from the Package menu. You should
be able to chose a SQL server to save to.

Yes you have to do this for every package.


-----Original Message-----
From: [Email Address Removed]
Sent: Wednesday, 22 October 2003 1:44 p.m.
To: LazyDBA.com Discussion
Subject: help moving DTS Packages from One Server to another.


Hi,

I've some packages in Development server which needs to be run on the
production server, does anybody help me how to transfer Dts packages
from One Server to Another..

Regards,
Sree.



---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY Get
today's cartoon: http://www.LazyDBA.com To unsubscribe, e-mail:
mssqldba-[Email Address Removed] For additional commands, e-mail:
mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page