canuckconsulting
asked on
SSIS Move Connection managers from multiple packages to project connections
I am starting out with SSIS and using BIDS 2012 have created a dozen packages each with their own connection managers. Now that I am ready to move these packages to production I believe I should have used project connections. What is the best way for me update these packages to use shared connections?
Once this is done what is the best way to deploy the packages to the server such that the DB connections are updated to point to the appropriate data sources?
Once this is done what is the best way to deploy the packages to the server such that the DB connections are updated to point to the appropriate data sources?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Simply superb...thanks!
Put there connection string.
Use the same folder like C:\SSIS_Config as on production as on development server.
Edit config.xml file on each instance.
When you run SSIS package it will use different settings in different environment. No changes in SSIS is required.