title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic |
---|---|---|---|---|---|---|---|
catalog.remove_data_tap |
catalog.remove_data_tap |
chugugrace |
chugu |
03/06/2017 |
sql |
integration-services |
language-reference |
[!INCLUDEsqlserver-ssis]
[!INCLUDE SQL Server]
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) .
0 (success)
When the stored procedure fails, it throws an error.
None
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.
- The user does not have MODIFY permissions.