Implement Auditing Logging and Event Handling

Introduction

The Implement Auditing Logging and Event Handling module provides you with the instruction and server hardware to develop your hands on skills in the defined topics. This module includes the following exercises:

1. Implement Row Level Auditing in an SSIS Package

2. Configuring SSIS Container for Event Logging

3. Create Custom Logging to Track Errors using Event Handlers

4. Implement Alerts and Notification Mechanism

Exercise 1 - Implement Row Level Auditing in an SSIS Package

In this exercise, you will learn the following in Microsoft SQL Server 2012:

• How to implement row level auditing using the audit transformation in an SSIS package

Exercise 2 - Configuring SSIS Container for Event Logging

In this exercise, you will learn the following in Microsoft SQL Server 2012:

• Configure an SSIS Container for event logging using the appropriate log provider
• Log information about the status of each phase of the package execution

Exercise 3 - Create Custom Logging to Track Errors using Event Handlers

In this exercise, you will learn the following in Microsoft SQL Server 2012:

• Create custom logging to track errors using event handlers in an SSIS package

Exercise 4- Implement Alerts and Notification Mechanism

In this exercise, you will learn the following in Microsoft SQL Server 2012:

• Configure an SSIS package to use alerts to report errors in the package