catalog.execution_data_tapscatalog.execution_data_taps

适用于:Applies to: 是SQL ServerSQL Server(所有支持的版本)yesSQL ServerSQL Server (all supported versions) 是 Azure 数据工厂中的 SSIS Integration RuntimeSSIS Integration Runtime in Azure Data Factoryyes Azure 数据工厂中的 SSIS Integration RuntimeSSIS Integration Runtime in Azure Data Factory适用于:Applies to: 是SQL ServerSQL Server(所有支持的版本)yesSQL ServerSQL Server (all supported versions) 是 Azure 数据工厂中的 SSIS Integration RuntimeSSIS Integration Runtime in Azure Data Factoryyes 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.

另请参阅See Also

生成包执行的转储文件Generating Dump Files for Package Execution