sysssislog (Transact-SQL)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Contains one row for each logging entry that is generated by packages or their tasks and containers at run time. This table is created in the msdb database when you install Microsoft SQL Server Integration Services. If you configure logging to log to a different SQL Server database, a sysssislog table with this format is created in the specified database.

Note

Integration Services writes logging entries in this table only when packages use the SQL Server log provider.

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, in the package, that generated the logging entry.
sourceid uniqueidentifier The GUID of the executable in the package 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.

This feature is not implemented. The value in the endtime column is always the same as the value in the starttime column.
datacode int An optional integer value that typically indicates the result of running the container or task.
databytes image An optional byte array that contains additional information.
message nvarchar A description of the event and the information associated with the event.

See Also

Integration Services (SSIS) Logging