TransactionIsolationLevel Property (DTS)

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

Applies To

Package 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 Package object transaction executes

Remarks

TransactionIsolationLevel must be set to one of the DTSIsolationLevel values.

The default is ReadCommitted.

Data Type

DTSIsolationLevel

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetTransactionIsolationLevel(DTSIsolationLevel *pRetVal);

HRESULT SetTransactionIsolationLevel(DTSIsolationLevel NewValue);