sysssislog (Transact-SQL)


Updated: June 10, 2016

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.

System_CAPS_ICON_note.jpg Note

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

Column nameData typeDescription
idintThe unique identifier of the logging entry.
eventsysnameThe name of the event that generated the logging entry.
computernvarcharThe computer on which the package ran when the logging entry was generated.
operatornvarcharThe user name of the person who ran the package that generated the logging entry.
sourcenvarcharThe name of the executable, in the package, that generated the logging entry.
sourceiduniqueidentifierThe GUID of the executable in the package that generated the logging entry.
executioniduniqueidentifierThe GUID of the execution instance of the executable that generated the logging entry.
starttimedatetimeThe time the package began to run.
endtimedatetimeThe 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.
datacodeintAn optional integer value that typically indicates the result of running the container or task.
databytesimageAn optional byte array that contains additional information.
messagenvarcharA description of the event and the information associated with the event.

Integration Services (SSIS) Logging
Enable Package Logging in SQL Server Data Tools

Community Additions