This topic has not yet been rated - Rate this topic

TransSynchronizationAgent.DtsPackagePassword Property

SQL Server 2008

Gets or sets the owner password that used to access the Microsoft SQL Server 2000 Data Transformation Services (DTS) package specified by the DtsPackageFileName property.

Namespace: Microsoft.SqlServer.Replication
Assembly: Microsoft.SqlServer.Replication (in Microsoft.SqlServer.Replication.dll)

Syntax

C++

JScript

public virtual string DtsPackagePassword { get; set; }

Property Value

Type: System.String
A String value.

Implements

ITransSynchronizationAgent.DtsPackagePassword

Remarks

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

The DTS owner password must be provided for this property. The required access cannot be obtained with the user password.

This property does not return the actual owner password of the DTS package specified by DtsPackageFileName, and only returns the value set on the current instance of TransSynchronizationAgent.

Reference

TransSynchronizationAgent Class

TransSynchronizationAgent Members

Microsoft.SqlServer.Replication Namespace

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD