Implement Auditing Logging and Event Handling
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...
Already have an account? Sign In »

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:
-
Implement Row Level Auditing in an SSIS Package
-
Configuring SSIS Container for Event Logging
-
Create Custom Logging to Track Errors using Event Handlers
-
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
See the full benefits of our immersive learning experience with interactive courses and guided career paths.