Business Intelligence Blogs

View blogs by industry experts on topics such as SSAS, SSIS, SSRS, Power BI, Performance Tuning, Azure, Big Data and much more! You can also sign up to post your own business intelligence blog.

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

Rate this article:
No rating

PatrickLeBlanc PatrickLeBlanc

Other posts by PatrickLeBlanc

Please login or register to post comments.