This article is work in progress..
SSIS 2012 includes a number of great enhancements that allow easier management of the SSIS environment. Before getting started with how dynamic configurations work in the project deployment mode let's review a few basic new concepts or features.
SSIS Catalog:
Environments:
Environment Variables:
Project deployment mode:
Package and project parameters:
Now that we have touched on this concepts let's walk through an example of how you can use parameters and environment variables to implement dynamic configurations.