Chapter 37. Logging Package Data

Most businesses want to keep track of the packages running on their servers. The logging options in SSIS allow you to record package information at runtime. This lesson shows you how to use those built-in logging options.

Although the logging options built into SSIS are limited, you have other ways to log information. One example is creating Execute SQL Tasks in the event handlers and passing in the system variables. However, creating and maintaining this type of logging can be time-consuming. There is also software available that creates a robust auditing framework on your packages, such as BI xPress from Pragmatic Works, Inc.