SSIS 2008 R2 - How to dynamically change connections during runtime
13,490
Solution 1
You would use expressions and populate a variable with the connection property you would like to change. In the properties of each object, there is a field called expressions, which you can open up and dynamically change anything.
Solution 2
Use expressions in the connection manager properties windows to construct the value in runtime
Author by
GordyII
Updated on June 26, 2022Comments
-
GordyII almost 2 years
I am using SQL Server SSIS 2008 R2.
I want to dynamically change a connection manager for OLEDB during runtime to point at a database determined during the running of the package.
This means that I cannot use configuration files.
How can I do this?