Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Applies to:
SQL Server
SSIS Integration Runtime in Azure Data Factory
Displays information for each data tap defined in an execution.
Column name | Data type | Description |
---|---|---|
data_tap_id | bigint | Unique identifier (ID) of the data tap. |
execution_id | bigint | Unique identifier (ID) for the instance of execution. |
package_path | nvarchar(max) | The package path for the data flow task where the data is tapped. |
dataflow_path_id_string | nvarchar(4000) | The identification string of the data flow path. |
dataflow_task_guid | uniqueidentifier | Unique ID of the data flow task. |
max_rows | int | The number of rows to be captured. If this value is not specified then all rows will be captured. |
filename | nvarchar(4000) | The name of the data dump file. For more information, see Generating Dump Files for Package Execution. |
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
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.
Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register today