Course Description
SSIS and SSDT both offer tools and techniques to monitor and optimize SSIS solutions. In this course, you'll learn how to implement auditing, logging, and event handling.
Learning Objectives
Auditing, Logging, and Event Handling
- Start the course
- audit package execution by using system variables
- propagate events
- use log providers
- log an SSIS execution
- create alerting and notification mechanisms
- use event handlers in SSIS to track ETL events and errors
- implement custom logging