This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
The DTSPackageName property specifies a Data Transformation Services (DTS) package name to use during a replication operation.
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.
|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 or later" are returned.|