THIS TOPIC APPLIES TO: yesSQL Server (starting with 2012)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Displays information for each data tap defined in an execution.

Column nameData typeDescription
data_tap_idbigintUnique identifier (ID) of the data tap.
execution_idbigintUnique identifier (ID) for the instance of execution.
package_pathnvarchar(max)The package path for the data flow task where the data is tapped.
dataflow_path_id_stringnvarchar(4000)The identification string of the data flow path.
dataflow_task_guiduniqueidentifierUnique ID of the data flow task.
max_rowsintThe number of rows to be captured. If this value is not specified then all rows will be captured.
filenamenvarchar(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

System_CAPS_ICON_note.jpg 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.

Generating Dump Files for Package Execution

Community Additions