Applies To: SQL Server 2014, SQL Server 2016 Preview
Provides information from the execution log for a collection set or package.
Applies to: SQL Server (SQL Server 2008 through current version).
Identifies each collection set execution. Used to join this view with other detailed logs. Is not nullable.
Identifies the parent package or collection set. Is not nullable. The IDs are chained in the parent-child relationship, which enables you to determine which package was started by which collection set. This view groups the log entries by their parent-child linkage and indents the names of the packages, so that the call chain is clearly visible.
Identifies the collection set or package that this log entry represents. Is not nullable.
Identifies a collection item. Is nullable.
The time that the collection set or package started. Is not nullable.
For continuously running packages, the last time that the package captured a snapshot. Is nullable.
The time the run completed for finished packages and collection sets. Is nullable.
Indicates whether the collection set activity was collecting data or uploading data. Is nullable.
0 = Collection
1 = Upload
Indicates the current status of the collection set or package. Is not nullable.
0 = running
1 = finished
2 = failed
Identifies who started the collection set or package. Is not nullable.
Identifies the collection set or package that generated this log. Is nullable.
The name of the package that generated this log. Is nullable.
Provides a link to the SSIS log table. Is nullable.
If the collection set or package failed, the most recent error message for that component. Is nullable. To obtain more detailed error information, use the fn_syscollector_get_execution_details (Transact-SQL) function.
Requires SELECT for dc_operator.