I want to change the connection information of a large number of dts
packages when migrating from development to producton.....
How can I do so?


Thanks in advance...



Ajay

The best way would have been to plan for this up front and parameterise the
connection information. If that has not been done then you can either
implement it in each of your packages now or you can loop through each
package programmatically and set the information then save it back.

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.Konesans.com


"Ajay Garg" <ajayz90 (AT) hotmail (DOT) com> wrote

Ajay,

Be aware of login information as well. You can and should parameterize it
too, unless you use 'log to SQL server' feature. Login information for 'log
to SQL server' does not change during run time so parametrizing it would not
do any good. In that case use windows authentication, which you should
anyway and a server alias. If you used sql authentication and real server
name for 'log to SQL server' you have to re-save the packages every time any
if that change.

Ilya

"Ajay Garg" <ajayz90 (AT) hotmail (DOT) com> wrote