DTSTransactionOption Enumeration
This API supports the SQL Server 2012 infrastructure and is not intended to be used directly from your code.
Describes transaction supportability and specifies whether a container participates in transactions.
Namespace: Microsoft.SqlServer.Dts.Runtime.Wrapper
Assembly: Microsoft.SqlServer.DTSRuntimeWrap (in Microsoft.SqlServer.DTSRuntimeWrap.dll)
Syntax
'Declaration
Public Enumeration DTSTransactionOption
'Usage
Dim instance As DTSTransactionOption
public enum DTSTransactionOption
public enum class DTSTransactionOption
type DTSTransactionOption
public enum DTSTransactionOption
Members
| Member name | Description | |
|---|---|---|
| DTSTO_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. | |
| DTSTO_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. | |
| DTSTO_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. |
Remarks
For more information, see DTSTransactionOption.