SSIS Tutorial - Parameterising Connection Managers

Another video brought to you by BeardedDev, bringing you tutorials on Business Intelligence, SQL Programming and Data Analysis.

If you are not familiar with how to create Connection Managers in SQL Server Integration Services please check out the video here:
youtu.be/5SNHNlBmbi8

Connection Managers exist at both the Project and Package Scope

In this SSIS Tutorial, I show examples of how to parameterise both Project and Package Connection Managers.

The examples I cover are parameterising an OLE DB Connection and a flat file Connection.

Parameterising Connection Strings allow to us to easily make changes because of a server move or new file location. We know only have to make the changes in one place allowing us more control.

SQL Server Data Tools is extremely helpful in helping us to parameterise and most of the work is done for us.

I also cover examples on once the project is deployed to the server how we can change the connection strings in the SSIDB Catalog.

Parameters can only be changed before package execution not during, if this is the case the value needs to be passed to a variable.

Please feel free to post comments.