DTS Programming

TransactionIsolationLevel Property

The TransactionIsolationLevel property specifies the isolation level at which a Package2 object transaction executes if the UseTransaction property is set to TRUE.

Applies To

Package Object

Package2 Object

Syntax

object.TransactionIsolationLevel[= value]

Part	Description
object	Expression that evaluates to an object in the Applies To list
value	Isolation level at which a Package2 object transaction executes

Data Type

DTSIsolationLevel

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetTransactionIsolationLevel(DTSIsolationLevel *pRetVal);

HRESULT SetTransactionIsolationLevel(DTSIsolationLevel NewValue);

Remarks

The default is ReadCommitted.