DTSTransactionOption Enumeration
Describes transaction supportability and specifies whether a container participates in transactions.
Assembly: Microsoft.SqlServer.ManagedDTS (in Microsoft.SqlServer.ManagedDTS.dll)
| Member name | Description | |
|---|---|---|
| NotSupported | Specifies that no transaction will be started for this container, and consequently, the outcome of the current transaction, if one has been started by a parent container, will not affect the data that may be altered during execution of this container. This means that changes will not roll back, even if the parent container started a transaction. | |
| Required | Specifies that this container will cause a new transaction to be started unless the parent container already has a transaction, in which case, the parent’s transaction will be joined. | |
| Supported | Specifies that this container will not start a transaction. However, it will participate in a transaction if the parent container started one. This is the default. |
This enumeration is used by containers to indicate whether the container participates in transactions.