Course Details

Previous Page


Auditing, Logging, and Event Handling


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number


Overview/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.

Target Audience
Data warehouse developers and database administrators who create and manage business intelligence solutions as part of their daily tasks, which include implementing data warehouse databases, extracting and transforming data as part of an ETL solution, and data cleansing

Prerequisites
None

Expected Duration (hours)
0.9

Lesson 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
  • Course Number:
    md_idwm_a14_it_enus