SQL Server Integration Services

Example 8: Logging

Logging lets you monitor and helps you troubleshoot package execution by tracing task and container events. Logging can be enabled at the task, container, or package level.

A log provider writes logging information to various destination types in different formats. The following log providers ship with SSIS: text file, SQL Server Provider, Windows Event Log, SQL Server, and XML file. This example adds and configures logging for the package built in Example 7: Looping and Control Flow.

1. Copy Example7.dtsx following the instructions at the beginning of Example 2: Aggregation, and rename it Example8.dtsx. Open the Example8 package and select the Control Flow designer.

2. Select SSIS → Logging... from the main menu to open the Configure SSIS Logs dialog shown in the following figure.

   

   Figure 63. Configure SSIS Logs dialog

3. In the "Providers and Logs" tab, select "SSIS log provider for XML files" from the "Provider type" dropdown. Click the Add... button to add the provider for XML files to those used for the container. You can add multiple logs, but in this example, we will use only an XML file.

4. Change the value in the Name cell to Example 8: Logging XML Log.

5. Click the Configuration dropdown to open the File Connection Manager Editor dialog.

6. Select Create File from the "Usage type" dropdown. Click the Browse button to open the Select File dialog.

7. Set the File property to Example8.log ...