Logging over Legacy Deployment Model

The approach used in the previous version of SSIS is called Legacy Deployment Model or Package Deployment Model. By default, in an empty solution, SSIS sets the SSIS solution using the Project Deployment Mode, but converting can easily be done as the following screenshot demonstrates:

All the SSIS logging created through the SSIS Log Provider or even through custom logging is still very useful if the deployment approach is Legacy. However, the new deployment approach has a new SSIS Catalog that automatically logs all package execution activity along with some built-in reports that provide a more intuitive perspective over log activity and also provide information about all deployments and configurations done to the SSIS Catalog.

Getting ready

To get ready for this recipe, follow these steps:

1. Open SQL Server Management Studio (SSMS) and execute the SQL Statement included in the file C:\SSIS\Ch02_Control Flow Tasks\Files\R09_CreateDimProduct.sql

2. Open SQL Server...