Blog Post

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.

image

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

You rated this post out of 5. Change rating

Share

Share

Rate

You rated this post out of 5. Change rating