Thanks in Advance,

I recently had to move about 200 DTS packages from one server to
another in a hurry. The Source to Destination task worked fine with at
least one exception. Many of the tasks refer to the old server in the
Source connection and have to be changed. If I redo this, what is the
best method of substituting the new server into each task for the old
server? I suspect some kind of scripting task would do it.

Kind Regards,

Mark Simmerman
Napa, California

http://www.mutuallybeneficial.com/in...s_portable.htm

The above article details how to use Dynamic Properties and command line
parameters to make DTS packages portable

--
David Lundell
Principal Consultant and Trainer
www.MutuallyBeneficial.com
David (AT) MutuallyBeneficial (DOT) com

"Mark" <xxxdbaxxx (AT) gmail (DOT) com> wrote