Summary

In this lab, you have explored the Populate DW Integration Services project designed to populate the Adventure Works data warehouse. You explored the design of the packages and specifically the use of a project connection manager and package parameters – both being new features in Integration Services for SQL Server 2012

Next you will created the SSIS Catalog and then deployed the Populate DW project to the catalog. Once deployed you executed the Master package and reviewed the execution results using the dashboard and standard reports.