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 Project Deployment Model

While in the Legacy Deployment Model approach the logging data was recorded in the Sysssislog table, in this new model approach all logging data is stored in tables under a new database created exclusively for this approach and named SSISDB. This database supports the SSIS catalog, which is the central storage and administration point for Integration Services projects, packages, parameters, and environments.

This means that data is centralized, more complete, and anyone (with the respective permissions to the SISDB database) has the ability to build their own custom reports based on the log data. The SSIS catalog provides four different log levels—Basic (default log level), None, Performance, and Verbose.

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