O'Reilly logo

Microsoft SQL Server 2012 Integration Services: An Expert Cookbook by Pedro Perfeito, Reza Rad

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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:

Logging over Legacy Deployment Model

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required