DTS Programming

UseTrustedConnection Property

The UseTrustedConnection property specifies whether the connection connects to the data source using Windows Authentication security mode.

Applies To

Connection Object	ExecutePackageTask Object
Connection2 Object

Syntax

object.UseTrustedConnection [= value]

Part	Description
object	Expression that evaluates to an object in the Applies To list
value	Value indicating whether to connect using Windows Authentication

Data Type

Boolean

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetUseTrustedConnection(VARIANT_BOOL *pRetVal);

HRESULT SetUseTrustedConnection(VARIANT_BOOL NewValue);

Remarks

You need to specify values for the UserID and Password properties if UseTrustedConnection is FALSE.

Note It is recommended that you connect to an instance of Microsoft® SQL Server™ using Windows Authentication instead of SQL Server Authentication. To use Windows Authentication, set UseTrustedConnection to TRUE.