I have an SSIS package which calls many other SSIS packages. Each of
these was created with the im****t wizard in SSMS. As a result, they
all have SourceConnectionOLEDB and DestinationConnectionOLEDB
connections listed under the Connection Manager in the package
designer.
T deploy the packages to another server I have saved all of the
packages as files. I can open each file in BIDS to create the
packages on the new server but it will have a different name and
different database names. I do not want to have to edit every single
source and destination connection for each package in BIDS.
Is there a quick way round this?
