|A plethora of connection managers in the old days...|
What has changed in SSIS 2012?With SSIS 2012 when you use the new project deployment model, the Execute package task is now easier to setup and configure:
For one, we just need to select the name of the package – any package within the current project – from a drop down list, as we will save quite a few clicks a we don’t need to create a configuration manager each time.
|Point and click|
Second, we have the ability to bind the parameters of the child package to variable or parameters in the parent package, and once again, just by selecting the appropriate values from the dropdown lists.
|Nice: The execute package task 'sees' the parameters defined in the child package|
Now, remember these benefits are only available when using the new project deployment model.