Syntax

object.DTSPackageName [= value]

Parts

Object

Expression that evaluates to an object in the Applies To list

Value

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

Remarks

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

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

Note  If an application calls DTSPackageName on 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" are returned.

See Also