SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

SSIS 2012: Project Reference

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


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 .

Leave a Comment

Please register or log in to leave a comment.