sp_getsubscriptiondtspackagename (Transact-SQL)

APPLIES TO: yesSQL Server noAzure SQL Database noAzure 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


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


[ @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.


sp_getsubscriptiondtspackagename is used in snapshot replication and transactional replication.


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