DTSTransactionOption Enumeration

 

This API supports the product 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)

public enum class DTSTransactionOption

Member nameDescription
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.

For more information, see DTSTransactionOption.

Return to top
Show: