Hi all,
i've an aplication called DTSBackup (Copyright © 1999 Darren Green) that i
don´t know if you've eard about. But this app backup one or more DTS into a
DIR and then u can restore them from there to another sqlserver instance.
Nothing new!

My problem is that after i restore the DTS in an instance with, for example,
the name B, all my DTS are still with the connections poiting the server
instance A.

To alter this i've to do it 1 by 1, and u can imagine what a stupid a long
task it is.

Does any one knows a better and faster why to do this?

Thank u all,
Ricardo Silva@Portugal

The application Darren moves packages yes. The connections inside are
for you <grin>

Have your connections read from an external data source and change the
value in that data source. Short of that you are going to have to
traverse each package and change the properties.



"Ricardo Silva" <Ricardo Silva (AT) discussions (DOT) microsoft.com> wrote in
message news:Ricardo Silva (AT) discussions (DOT) microsoft.com: