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

Changing the Logging Level
Now that you know what the different logging levels are and when you would use each
one, let's walk through changing the logging level. You can do this in either of two
ways: through the execution interface or through a command-line execution.
To modify the logging level through the execution interface, you will connect your
Integration Services Catalog, right-click on the desired package, and select Execute.
On Execute Package screen, you will see the Logging Level option on the Advanced
tab. By default, the option is set to Basic, as shown in Figure 15-7 . Alternatively, you
can modify this value to another logging level to see more or less in the logging tables.
Figure 15-7 . Execute Package screen
The other option is to modify logging through the command line. All packages can
be executed through the command line, and you can set a logging level associated with
an individual execution.