Skip to content

sp-changesubscriptiondtsinfo-transact-sql.md

Latest commit

 

History

History
73 lines (50 loc) · 2.8 KB

sp-changesubscriptiondtsinfo-transact-sql.md

File metadata and controls

73 lines (50 loc) · 2.8 KB
title sp_changesubscriptiondtsinfo (Transact-SQL)
description sp_changesubscriptiondtsinfo changes the Data Transformation Services (DTS) package properties of a subscription.
author markingmyname
ms.author maghan
ms.reviewer randolphwest
ms.date 06/23/2025
ms.service sql
ms.subservice replication
ms.topic reference
f1_keywords
sp_changesubscriptiondtsinfo
sp_changesubscriptiondtsinfo_TSQL
helpviewer_keywords
sp_changesubscriptiondtsinfo
dev_langs
TSQL

sp_changesubscriptiondtsinfo (Transact-SQL)

[!INCLUDE SQL Server SQL MI]

Changes the Data Transformation Services (DTS) package properties of a subscription. This stored procedure is executed at the Subscriber on the subscription database.

:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: Transact-SQL syntax conventions

Syntax

sp_changesubscriptiondtsinfo
    [ @job_id = ] job_id
    [ , [ @dts_package_name = ] N'dts_package_name' ]
    [ , [ @dts_package_password = ] N'dts_package_password' ]
    [ , [ @dts_package_location = ] N'dts_package_location' ]
[ ; ]

Arguments

[ @job_id = ] job_id

The job ID of the Distribution Agent for the push subscription. @job_id is varbinary(16), with no default. To find the Distribution Job ID, run sp_helpsubscription or sp_helppullsubscription.

[ @dts_package_name = ] N'dts_package_name'

Specifies the name of the DTS package. @dts_package_name is sysname, with a default of NULL. For example, to specify a package named DTSPub_Package, you would specify @dts_package_name = N'DTSPub_Package'.

[ @dts_package_password = ] N'dts_package_password'

Specifies the password on the package. @dts_package_password is sysname, with a default of NULL, which specifies that the password property is to be left unchanged.

Note

A DTS package must have a password.

[ @dts_package_location = ] N'dts_package_location'

Specifies the package location. @dts_package_location is nvarchar(12), with a default of NULL, which specifies that the package location is to be left unchanged. The location of the package can be changed to distributor or subscriber.

Return code values

0 (success) or 1 (failure).

Remarks

sp_changesubscriptiondtsinfo is used for snapshot replication and transactional replication that are push subscriptions only.

Permissions

Only members of the sysadmin fixed server role, db_owner fixed database role, or the creator of the subscription can execute sp_changesubscriptiondtsinfo.

Related content