Configure Logging for ETL Package

Practice Labs Module
Time
21 minutes
Difficulty
Intermediate

The "Configure Logging for ETL Package" module provides you with the instructions and devices to develop hands on skills in the following topics: Adding and configuring logging for an ETL Package.

Join over 3 million cybersecurity professionals advancing their career
Sign up with
Required fields are marked with an *
or

Already have an account? Sign In »

Overview

Introduction

The Configure Logging for ETL Package module provides you with the instructions and devices to develop hands on skills in the following topics:

  • Adding and configuring logging for an ETL Package

Exercise 1 - Creating a Simple ETL Package

In this exercise, you will create a simple ETL package in the SSIS designer. The ETL package extracts data from an OLE DB data source and writes the data to another OLE DB data source.

Exercise 2 - Adding and Configuring Logging for an ETL package

SQL Server Integration Services includes various log providers. These log providers enable you to implement logging in packages, containers, and tasks. Logging enables you to capture run-time information about a package. For example, you can get the name of the operator who ran the package and the duration the package ran.

Learning Partner
Comprehensive Learning

See the full benefits of our immersive learning experience with interactive courses and guided career paths.