Dynamic connection managers
Connections can be created at package level or project level, and in both cases these connections can be configured to change at runtime. A common scenario where a dynamic connection is required happens when a package should execute against different development or production environments. The option of doing it manually each time a connection change, can be time consuming and even more dangerous.
Getting ready
To get ready for this recipe, follow these steps:
Open SQL Server Data Tools (SSDT) and create a new SSIS project.
Provide a name and a location for the SSIS project and proceed.
Select the package created by default and rename it to:
P01_DynamicConnections.dtsx.
How to do it...
Imagine the scenario where customer data is read from SQL database and inserted into a flat file. This simple example has two connections that will be configured to be changed at runtime through expressions that use SSIS variables that store the respective connection strings inside.
Add...
