sp_getsubscriptiondtspackagename (Transact-SQL)

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

Returns the name of the Data Transformation Services (DTS) package used to transform data before they are sent to a Subscriber. This stored procedure is executed at the Publisher on any database.

Topic link icon Transact-SQL Syntax Conventions

Syntax


sp_getsubscriptiondtspackagename [ @publication = ] 'publication'   
    [ , [ @subscriber = ] 'subscriber' ]  

Arguments

[ @publication= ] 'publication'
Is the name of the publication. 'publication' is sysname, with no default.

[ @subscriber=] 'subscriber'
Is the name of the Subscriber. subscriber is sysname, with a default of NULL.

Return Code Values

0 (success) or 1 (failure)

Result Sets

Column name Data type Description
new_package_name sysname The name of the DTS package.

Remarks

sp_getsubscriptiondtspackagename is used in snapshot replication and transactional replication.

Permissions

Only members of the sysadmin fixed server role or the db_owner fixed database role can execute sp_getsubscriptiondtspackagename.