Partager via

  • Article

DTSPackageName Property

Cette fonctionnalité sera supprimée dans une prochaine version de Microsoft SQL Server. Évitez d'utiliser cette fonctionnalité dans de nouveaux travaux de développement et prévoyez de modifier les applications qui utilisent actuellement cette fonctionnalité.

The DTSPackageName property specifies a Data Transformation Services (DTS) package name to use during a replication operation.

Syntaxe

object
.DTSPackageName [= value]

Parts

  • object
    An expression that evaluates to an object in the Applies To list

  • value
    A string that specifies the name of the DTS package

Data Type

String

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetDTSPackageName(SQLDMO_LPBSTR pRetVal);
HRESULT SetDTSPackageName(SQLDMO_LPCSTR NewValue);

Notes

The DTSPackageName property specifies a DTS package name that Distribution Agent processes before data changes are applied at the Subscriber.

Prior to setting DTSPackageName, set AllowDTS to TRUE when configuring a TransPublication object. Next, set the DTSPackagePassword property (if the package is password protected), and then set the DTSPackageLocation property.

Notes

If an application calls DTSPackageNameon an instance of Microsoft SQL Server version 7.0, the constant, SQLDMO_E_SQL80ONLY, and the message "This property or method requires Microsoft SQL Server 2000 or later" are returned.