title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic |
---|---|---|---|---|---|---|---|
Lesson 3: Add Logging with SSIS |
Lesson 3: Add Logging with SSIS |
chugugrace |
chugu |
01/04/2019 |
sql |
integration-services |
tutorial |
[!INCLUDEsqlserver-ssis]
[!INCLUDEmsCoName] [!INCLUDEssISnoversion] includes logging features that let you troubleshoot and monitor package execution by providing a trace of task and container events. The logging features are flexible. You can enable logging at the package level, or on individual tasks or containers within the package. You select which events you want to log, and create multiple logs against a single package.
Log providers create the logs. Each log provider can write logging information to different formats and destination types. [!INCLUDEssISnoversion] provides the following log providers:
-
Text file
-
[!INCLUDEssSqlProfiler]
-
Windows Event log
-
[!INCLUDEssNoVersion]
-
XML file
In this lesson, you create a copy of the package that you created in Lesson 2: Add Looping with SSIS. Working with this new package, you then add and configure logging to monitor specific events during package execution. If you haven't completed either of the previous lessons, you can also copy the completed Lesson 2 package included with the tutorial.
Note
If you haven't already, see the Lesson 1 prerequisites.
This lesson contains the following tasks: