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.
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,
Other posts by PatrickLeBlanc