By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
448,679 Members | 1,063 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 448,679 IT Pros & Developers. It's quick & easy.

OLEDB configuration when deploying multiple SSIS packages

P: n/a
I have an SSIS package which calls many other SSIS packages. Each of
these was created with the import 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?
Jun 30 '08 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.