How To Support Multiple SQL Server Package Configurations in SSIS

Posted on SQL Server Central See other posts from SQL Server Central
Published on Tue, 21 Aug 2012 06:00:00 UT Indexed on 2012/08/27 21:50 UTC
Read the original article Hit count: 205

Filed under:

I have several applications that use SSIS packages and I want to be able to store all the configurations together in a single table when I deploy. When a package executes I need a way of specifying the "application" and having SSIS automatically handle the package configuration based on the application.

SQL Storage Compress Compress live data by 73% 
Red Gate's SQL Storage Compress reduces the size of live SQL Server databases, saving you disk space and storage costs. Learn more.

© SQL Server Central or respective owner