Microsoft SQL Server 2005 Integration Services

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.

Категории