DtsContainer.IsolationLevel Property

 

Gets or sets the isolation level of the transaction in the DtsContainer object.

Namespace:   Microsoft.SqlServer.Dts.Runtime
Assembly:  Microsoft.SqlServer.ManagedDTS (in Microsoft.SqlServer.ManagedDTS.dll)

Public Property IsolationLevel As IsolationLevel

Property Value

Type: System.Data.IsolationLevel

An integer value that corresponds to the isolation level.

The default value of this property is -1, or Unspecified. For more information about the available values, see the IsolationLevel enumerations that are used in the System.Data namespace, in ADO and in OLE DB.

The following table lists the values that are available for the IsolationLevel property.

Value

Isolation Level

-1

Unspecified

16

Chaos

256

ReadUncommitted

4096

ReadCommitted

65536

RepeatableRead

1048576

Serializable

The following code example creates a Package, which is a class that inherits from DtsContainer. The Package shows the use of several inherited properties.

Imports System
Imports System.Collections.Generic
Imports System.Text
Imports Microsoft.SqlServer.Dts.Runtime

Namespace Microsoft.SqlServer.SSIS.Samples
    Class Program
        Shared  Sub Main(ByVal args() As String)
            Dim app As Application =  New Application() 
            Dim pkg As Package =  New Package() 

            ' Package name must be assigned.
            pkg.Name = "My DtsContainer inheritance test package"

            ' Display the values that manually assigned.
            Console.WriteLine("Package Name: {0}", pkg.Name)

            ' Packages are assigned the following default values when created.
            Console.WriteLine("Package ID:           {0}", pkg.ID)
            Console.WriteLine("FailPackageOnFailure: {0}", pkg.FailPackageOnFailure)
            Console.WriteLine("FailParentOnFailure:  {0}", pkg.FailParentOnFailure)
            Console.WriteLine("Locale ID:            {0}", pkg.LocaleID)
            Console.WriteLine("Is DefaultLocaleID?   {0}", pkg.IsDefaultLocaleID)
            Console.WriteLine("Isolation Level:      {0}", pkg.IsolationLevel)
            Console.WriteLine("LoggingMode:          {0}", pkg.LoggingMode)
            Console.WriteLine("MaximumErrorCount:    {0}", pkg.MaximumErrorCount)
            Console.WriteLine("TransactionOption:    {0}", pkg.TransactionOption)
        End Sub
    End Class
End Namespace

Sample Output:

Package Name: My DtsContainer inheritance test package

Package ID: {2C2FAA96-35BA-4C5E-A39A-C5D7D30A0D79}

FailPackageOnFailure: False

FailParentOnFailure: False

Locale ID: 1033

Is DefaultLocaleID? False

Isolation Level: Serializable

LoggingMode: UseParentSetting

MaximumErrorCount: 1

TransactionOption: Supported

Return to top
Show: