sysdtslog90 (Transact-SQL)
Contains one row for each logging entry that is generated by packages or their tasks and containers at run time. This table is built in the msdb database when you install Microsoft SQL Server 2005 Integration Services (SSIS). If you configure logging to log to a different SQL Server database, a sysdtslog90 table with this format is created in the specified database.
| Column name | Data type | Description |
|---|---|---|
id |
int |
The unique identifier of the logging entry. |
event |
sysname |
The name of the event that generated the logging entry. |
computer |
nvarchar |
The computer on which the package ran when the logging entry was generated. |
operator |
nvarchar |
The user name of the person who ran the package that generated the logging entry. |
source |
nvarchar |
The name of the executable that generated the logging entry. |
sourceid |
uniqueidentifier |
The GUID of the executable that generated the logging entry. |
executionid |
uniqueidentifier |
The GUID of the execution instance of the executable that generated the logging entry. |
starttime |
datetime |
The time the package began to run. |
endtime |
datetime |
The time the package completed. |
datacode |
int |
An integer value that identifies the event associated with the log entry. The value 0 indicates the event provided no identifier. |
databytes |
image |
A byte array that identifies a return value. |
message |
nvarchar |
A description of the event and the information associated with the event. |
See Also
Other Resources
Integration Services Log Providers
Implementing Logging in Packages