O'Reilly logo

Smart Business Intelligence Solutions with Microsoft® SQL Server® 2008 by Kevin S. Goff Lynn Langit Davide Mauri, Sahil Malik, and John C. Welch

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 and Events

The Execution Results tab is a kind of a quick logging for package execution in BIDS. If you have configured any event handlers, as we did in the previous example with OnPostExecute event for the package, this window includes event execution information about these events as well. Figure 16-5 shows the logging that occurs during package execution.

The Execution Results tab includes information about fired event handlers.

Figure 16-5. The Execution Results tab includes information about fired event handlers.

You might also want to capture some or all of the package execution information to a permanent log location. SSIS logging is configured at the package level. To do this you simply right-click the control ...

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