Share via


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.

See Also

Reference

Microsoft.SqlServer.Dts.Runtime.Wrapper Namespace