catalog.execution_data_tapscatalog.execution_data_taps
适用于：Applies to: 
SQL ServerSQL Server（所有支持的版本）SQL ServerSQL Server (all supported versions) Azure 数据工厂中的 SSIS Integration RuntimeSSIS Integration Runtime in Azure Data Factory Azure 数据工厂中的 SSIS Integration RuntimeSSIS Integration Runtime in Azure Data FactorySQL ServerSQL Server（所有支持的版本）SQL ServerSQL Server (all supported versions) Azure 数据工厂中的 SSIS Integration RuntimeSSIS Integration Runtime in Azure Data Factory Azure 数据工厂中的 SSIS Integration RuntimeSSIS Integration Runtime in Azure Data Factory
显示在执行中定义的每个数据分流点的信息。Displays information for each data tap defined in an execution.
| 列名称Column name | 数据类型Data type | 说明Description |
|---|---|---|
| data_tap_iddata_tap_id | bigintbigint | 数据分流点的唯一标识符 (ID)。Unique identifier (ID) of the data tap. |
| execution_idexecution_id | bigintbigint | 执行实例的唯一标识符 (ID)。Unique identifier (ID) for the instance of execution. |
| package_pathpackage_path | nvarchar(max)nvarchar(max) | 分流数据的数据流任务的包路径。The package path for the data flow task where the data is tapped. |
| dataflow_path_id_stringdataflow_path_id_string | nvarchar(4000)nvarchar(4000) | 数据流路径的标识字符串。The identification string of the data flow path. |
| dataflow_task_guiddataflow_task_guid | uniqueidentifieruniqueidentifier | 数据流任务的唯一 ID。Unique ID of the data flow task. |
| max_rowsmax_rows | intint | 要捕获的行数。The number of rows to be captured. 如果未指定此值，则将捕获所有行。If this value is not specified then all rows will be captured. |
| filenamefilename | nvarchar(4000)nvarchar(4000) | 数据转储文件的名称。The name of the data dump file. 有关详细信息，请参阅 生成包执行的转储文件。For more information, see Generating Dump Files for Package Execution. |
权限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.