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 name Data type Description
data_stats_id bigint Unique identifier (ID) of the data.
execution_id bigint Unique ID for the instance of execution.
package_name nvarchar(260) The name of the first package that was started during execution.
task_name nvarchar(4000) The name of the data flow task.
dataflow_path_id_string nvarchar(4000) The identification string of the data flow path.
dataflow_path_name nvarchar(4000) The name of the data flow path.
source_component_name nvarchar(4000) The name of the data flow component that sent the data.
destination_component_name nvarchar(4000) The name of the data flow component that received the data.
rows_sent bigint The number of rows sent from the source component.
created_time datatimeoffset(7) The time when the values were obtained.
execution_path nvarchar(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


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.