• Online, Self-Paced
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

Framework Connections

The materials within this course focus on the NICE Framework Task, Knowledge, and Skill statements identified within the indicated NICE Framework component(s):

Specialty Areas

  • Data Administration
  • Systems Administration
  • Systems Development