Logging Schema


The logging schema contains the fields shown in Table 11.1.

Table 11.1. Integration Services Logging Schema

Element

Description

Computer

The name of the computer on which the log event occurred.

Operator

The identity of the user who launched the package.

SourceName

The name of the container or task in which the log event occurred.

SourceID

The GUID ID of the container in which the log event occurred.

ExecutionID

The GUID of the package execution instance. The ExecutionID is uniquely generated for every package execution.

MessageText

The message associated with the log entry.

DataCode

The log event-specific code that indicates the content of the DataBytes field.

DataBytes

A byte array specific to the log entry. The meaning of this field varies by log entry. It is typically used as a log payload and can contain data or text.

StartTime

The time the log event started.

EndTime

The time the log event completed.




Microsoft SQL Server 2005 Integration Services
Microsoft SQL Server 2005 Integration Services
ISBN: 0672327813
EAN: 2147483647
Year: 2006
Pages: 200
Authors: Kirk Haselden

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net