TechNet
Export (0) Print
Expand All

catalog.execution_data_statistics

 

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

This view displays a row each time a data flow component sends data to a downstream component, for a given package execution. The information in this view can be used to compute the data throughput for a component.

Column nameData typeDescription
data_stats_idbigintUnique identifier (ID) of the data.
execution_idbigintUnique ID for the instance of execution.
package_namenvarchar(260)The name of the first package that was started during execution.
task_namenvarchar(4000)The name of the data flow task.
dataflow_path_id_stringnvarchar(4000)The identification string of the data flow path.
dataflow_path_namenvarchar(4000)The name of the data flow path.
source_component_namenvarchar(4000)The name of the data flow component that sent the data.
destination_component_namenvarchar(4000)The name of the data flow component that received the data.
rows_sentbigintThe number of rows sent from the source component.
created_timedatatimeoffset(7)The time when the values were obtained.
execution_pathnvarchar(max)The execution path of the component.
  • When there are multiple outputs from the component, a row is added for each of the outputs.

  • By default, when an execution is started, the information about the number of rows that are sent is not logged.

  • To view this data for a given package execution, set the logging level to Verbose. For more information, see Enable Logging for Package Execution on the SSIS Server.

This view requires one of the following permissions:

  • READ permission on the instance of execution

  • Membership to the ssis_admin database role

  • Membership to the sysadmin server role

System_CAPS_ICON_note.jpg Note


When you have permission to perform an operation on the server, you also have permission to view information about the operation. Row-level security is enforced; only rows that you have permission to view are displayed.

Community Additions

ADD
Show:
© 2016 Microsoft