Changing a Connection in DTS Local packages

Many of our Local packages in Data Transformation Services has the job of
copying data from one database on one server to another database on another
server. The package typically has 2 Connections defined.
Now we want to move the "destination" database to a new server. Is there any
way this can be done without editing each package in the "Design Package"
GUI
Thanks in advance
Henrik.You can use UDL files for the connection; you can change the properties
programmatically; you can use the Dynamic Properties task to change settings
at runtime.
--
Dejan Sarka, SQL Server MVP
FAQ from Neil & others at: http://www.sqlserverfaq.com
Please reply only to the newsgroups.
PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Henrik Hjøllund Hansen" <hh@.dlf.dk> wrote in message
news:bicqd4$2hmp$1@.news.cybercity.dk...
> Many of our Local packages in Data Transformation Services has the job of
> copying data from one database on one server to another database on
another
> server. The package typically has 2 Connections defined.
> Now we want to move the "destination" database to a new server. Is there
any
> way this can be done without editing each package in the "Design Package"
> GUI
>
> Thanks in advance
>
> Henrik.
>
>