timmitchell.net
Using Project Connections in SSIS - Tim Mitchell
In SQL Server Integration Services, connection managers are used as gateways for most any external read and write operation. Connection managers are type- and format-specific, and in the case of relational database connection managers, they are usually specific to vendor (Oracle, DB2, etc.) as well. In most use cases, the same connection will be used across multiple packages in the...