Datasheet

Chapter 1: Welcome to SQL Server Integration Services
18
The On Failure error data stream can be seen in Figure 1 - 9 as a red line connecting the transform Derived
Column Task to a Script Component Destination. The green lines show the normal happy path for the
Data Flow through the data pipeline.
Figure 1-8
Figure 1-9
Logging has also been improved in SSIS. It is now at a much finer detail than what was available in the
legacy DTS. More than a dozen events can be simply selected within each task or package for logging.
You can enable partial logging for one task and enable much more detailed logging for billing tasks.
Some of the examples of events that can be monitored are:
OnError , OnPostValidate , OnProgress ,
and
OnWarning , to name just a few. The logs can be written to nearly any connection: SQL Profiler, text
files, SQL Server, the Windows Event log, or an XML file. We go through some examples of this in
Chapter 17.
c01.indd 18c01.indd 18 8/28/08 12:01:22 PM8/28/08 12:01:22 PM