fn_syscollector_get_execution_details (Transact-SQL)

Applies to: SQL Server

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.

Transact-SQL syntax conventions

Syntax

  
fn_syscollector_get_execution_details ( log_id )  

Arguments

log_id
The local unique identifier for the execution log. log_id is int.

Table Returned

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 or agent that 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 that the package began to run.
endtime	datetime	The time that the package completed.
datacode	int	An integer value that identifies the event associated with the log entry. "0" indicates that 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.

Permissions

Requires SELECT permission for dc_operator.

See Also

Enable Package Logging in SQL Server Data Tools
Data Collection