One of the key aspects of working with SSIS is using Connections which are key to extracting data from data sources and populating data into destination databases. As the ETL project gets bigger, managing connections becomes a very important aspect. It can become very tedious if one is opening and closing packages as the SSIS packages are moved from one environment to another and at the same time changing connection strings. There are different configuration methods to alleviate some of the redundant work.
Andy Leonard SSIS expert recently gave a presentation on Managing SSIS connections in SSIS 2008.
He provides insight into connection managers and how to store connection strings and at the same time be compliant with the audits. Here is the link:
A very good video to get insight into connections in SSIS.
Post a Comment