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
Modifiable
Read/write
Prototype (C/C++)
HRESULT GetTransactionIsolationLevel(DTSIsolationLevel *pRetVal);
HRESULT SetTransactionIsolationLevel(DTSIsolationLevel NewValue);
Remarks
The default is ReadCommitted.
See Also
AutoCommitTransaction Property