Removes a data tap from a component output that is in an execution. The unique identifier for the data tap is associated with an instance of the execution.
catalog.remove_data_tap [ @data_tap_id = ] data_tap_id
[ @data_tap_id = ] data_tap_id
The unique identifier for the data tap that is created by using the catalog.add_data_tap stored procedure. The data_tap_id is bigint.
When a package contains more than one data flow tasks that have the same name, the data tap is added to the first data flow task with the given name.
To remove data taps, the instance of the execution must be in the created state (a value of 1 in the status column of the catalog.operations (SSISDB Database)view) .
When the stored procedure fails, it throws an error.
This stored procedure requires one of the following permissions:
MODIFY permissions on the instance of execution
Membership to the ssis_admin database role
Membership to the sysadmin server role
Errors and Warnings
The following list describes conditions that cause the stored procedure to fail.
- The user does not have MODIFY permissions.