Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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.