Logging and Reporting Patterns - SQL Server Integration Services Design Patterns - page 381

whether by mistyping a value or choosing an unavailable logging option. In some or-
ganizations, modifications to logging made at the package level may even result in the
package having to go through the change control process again. Ideally, you want to
make logging changes in an external location without touching the package at all.
In Integration Services 2012, you can choose from four different logging levels, as
described in Table 15-1 .
Table 15-1 . SSIS Logging Levels
Design Patterns
Now that you know how to set up and log information, let's walk through the following
design patterns:
1. Changing the logging level
2. Utilizing existing reports
3. Creating new reports