catalog.execution_data_statisticscatalog.execution_data_statistics

适用对象:是SQL Server 是Azure 数据工厂中的 SSIS Integration Runtime APPLIES TO: yesSQL Server yesSSIS Integration Runtime in Azure Data Factory

适用对象: 是SQL Server 否Azure SQL 数据库 否Azure Synapse Analytics (SQL DW) 否并行数据仓库 APPLIES TO: yesSQL Server noAzure SQL Database noAzure Synapse Analytics (SQL DW) 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_iddata_stats_id bigintbigint 数据的唯一标识符 (ID)。Unique identifier (ID) of the data.
execution_idexecution_id bigintbigint 执行实例的唯一 ID。Unique ID for the instance of execution.
package_namepackage_name nvarchar(260) nvarchar(260) 在执行过程中启动的第一个包的名称。The name of the first package that was started during execution.
task_nametask_name nvarchar(4000)nvarchar(4000) 数据流任务的名称。The name of the data flow task.
dataflow_path_id_stringdataflow_path_id_string nvarchar(4000)nvarchar(4000) 数据流路径的标识字符串。The identification string of the data flow path.
dataflow_path_namedataflow_path_name nvarchar(4000)nvarchar(4000) 数据流路径的名称。The name of the data flow path.
source_component_namesource_component_name nvarchar(4000)nvarchar(4000) 发送数据的数据流组件的名称。The name of the data flow component that sent the data.
destination_component_namedestination_component_name nvarchar(4000)nvarchar(4000) 接收数据的数据流组件的名称。The name of the data flow component that received the data.
rows_sentrows_sent bigintbigint 从源组件发送的行数。The number of rows sent from the source component.
created_timecreated_time datatimeoffset(7)datatimeoffset(7) 获取值的时间。The time when the values were obtained.
execution_pathexecution_path nvarchar(max)nvarchar(max) 组件的执行路径。The execution path of the component.

RemarksRemarks

  • 有来自组件的多个输出时,为每个输出添加一行。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. 有关详细信息,请参阅 在 SSIS 服务器上启用包执行的日志记录For more information, see Enable Logging for Package Execution on the SSIS Server.

权限Permissions

此视图需要下列权限之一:This view requires one of the following permissions:

  • 针对执行实例的 READ 权限READ permission on the instance of execution

  • ssis_admin 数据库角色的成员资格Membership to the ssis_admin database role

  • sysadmin 服务器角色的成员资格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.