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.