Jason won the SQL BI Guru gold medal for October! Here's his winning article...
By Jason Brugger December 8, 2013
SSIS Package Configurations allows property values which are particular to a given SQL Server instance to be customized for that instance without modification to the underlying package. To quote SQL BOL, "SQL Server Integration Services provides package configurations that you can use to update the values of [package] properties at run time." If unfamiliar with package configurations...
Here's an excerpt:
Next, complete the Package Configuration Wizard and specify the view as the configuration source:
Read the article here: Using a View to Mask Multi-Server SSIS Package Configurations
- Ninja Ed