One of the less advertised enhancements of SSIS in SQL Server 2012 is the Project Reference type available when using the Execute Package task. Open the Execute Package Task Editor and select Package from the left window. Select Project Reference for the ReferenceType property.
Now you can reference any package that exists in the same project. Just click the drop down list labeled PackageNameFromProjectReference and select the package from the list. This is especially useful when building Master Packages for Data Warehouse loads. This streamlines the process of configuration and deployment by reducing the need to manage package locations (file or server).
Talk to you soon,
Patrick LeBlanc



Subscribe to this blog
Briefcase
Print
Posted by sabotta on 24 October 2011
For more information about this enhancement, see the SSIS Team Blog post "Changes to the Execute Package Task" at blogs.msdn.com/.../changes-to-the-execute-package-task.aspx .