DTS Programming

DestUseTransaction Property

The DestUseTransaction property sets or returns a value indicating whether the operations of the task are performed within a transaction on the destination server.

Applies To

TransferObjectsTask2 Object

Syntax

object.DestUseTransaction [= boolean]

Part	Description
object	Expression that evaluates to a TransferObjectsTask2 object.
boolean	Boolean that specifies whether operations are performed within a transaction on the destination server.

Data Type

Boolean

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetDestUseTransaction(VARIANT_BOOL* pRetVal);

HRESULT SetDestUseTransaction(VARIANT_BOOL pRetVal);

Remarks

The default is FALSE. Operations do not use a transaction.