March 2007
Beginner to intermediate
88 pages
1h 52m
English
Content preview from SQL Server Integration ServicesBecome an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
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.
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.
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
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.
Change the value in the Name cell to Example 8: Logging XML Log.
Click the Configuration dropdown to open the File Connection Manager Editor dialog.
Select Create File from the "Usage type" dropdown. Click the Browse button to open the Select File dialog.
Set the File property to Example8.log ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.