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.
To get ready for this recipe, follow these steps:
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...