Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All


Applies To: SQL Server 2014, SQL Server 2016 Preview

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

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.

0 (success)

When the stored procedure fails, it throws an error.

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) .

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft