Applies To: SQL Server 2014, SQL Server 2016 Preview
Returns a portion of the SSIS log (sysssislog) matching the package_execution_id for the given package. The table contains one row for each logging entry that is generated at run time by packages or their tasks and containers.
The local unique identifier for the execution log. log_id is int.
The unique identifier of the logging entry.
The name of the event that generated the logging entry.
The computer on which the package ran when the logging entry was generated.
The user name of the person or agent that ran the package that generated the logging entry.
The name of the executable that generated the logging entry.
The GUID of the executable that generated the logging entry.
The GUID of the execution instance of the executable that generated the logging entry.
The time that the package began to run.
The time that the package completed.
An integer value that identifies the event associated with the log entry. "0" indicates that the event provided no identifier.
A byte array that identifies a return value.
A description of the event and the information associated with the event.
Requires SELECT permission for dc_operator.