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.
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.
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
The following list describes conditions that cause the stored procedure to fail.
(1500 characters remaining)
Thank you for your feedback