DTSPackageFileName Property (Replication ActiveX)

The DTSPackageFileName property returns or sets the name and path of a Microsoft® SQL Server™ 2000 Data Transformation Services (DTS) package used to transform command rowsets before they are applied to a Subscriber.

Syntax

object.DTSPackageFileName [= PackageSpec]
Part Description

object

Expression that evaluates to a SQLDistribution Object (Replication ActiveX) object.

PackageSpec

Fully qualified path to a DTS package.

Applies To

SQLDistribution Object (Replication ActiveX)

Remarks

This property is only supported for packages created in SQL Server 2000 and requires that the SQL Server 2000 DTS runtime be installed. For more information, see Transforming Published Data.

If the DTS package is stored in Microsoft SQL Server, the value of this property is the package name. If the package is stored in a file, the property value is the file specification.

Data Type

String

Modifiable

Read/write

Prototype (C/C++)

HRESULT DTSPackageFileName(BSTR pVal);
HRESULT DTSPackageFileName(BSTR* pVal);

See Also

Reference

DTSPackagePassword Property (Replication ActiveX)

Help and Information

Getting SQL Server 2005 Assistance