Export (0) Print
Expand All

ConnectionManager.SupportsDTCTransactions Property

Returns a Boolean that indicates if the connection supports Microsoft Distributed Transaction Coordinator (MS DTC) transactions.

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

'Declaration
Public ReadOnly Property SupportsDTCTransactions As Boolean 
	Get
'Usage
Dim instance As ConnectionManager 
Dim value As Boolean 

value = instance.SupportsDTCTransactions

Property Value

Type: Boolean
true if the connection supports MS DTC transactions; otherwise, false.

The following code example loads an existing package that has two connections. It iterates through the connection managers in the package and prints out the values for the various properties, including the Boolean, SupportsDTCTransactions.

Imports System
Imports System.Collections.Generic
Imports System.Text
Imports Microsoft.SqlServer.Dts.Runtime
 
Namespace Connections_Collection
    Class Program
        Shared  Sub Main(ByVal args() As String)
           ' The package is one of the SSIS Samples.
            Dim mySample As String =  "C:\Program Files\Microsoft SQL Server\100\Samples\Integration Services\Package Samples\CalculatedColumns Sample\CalculatedColumns\CalculatedColumns.dtsx" 
 
            ' Create an application and load the sample.
            Dim app As Application =  New Application() 
            Dim pkg As Package =  app.LoadPackage(mySample,Nothing) 
            Dim myConns As Connections =  pkg.Connections 
            Dim connCount As Integer =  myConns.Count 
            Console.WriteLine("The number of connections in the package is: {0}", connCount)
 
            ' Enumerate over the collection, printing out
            ' the values for various properties.
            Dim connMgr As ConnectionManager
            For Each connMgr In myConns
                Console.WriteLine("ConnectionString:        {0}", connMgr.ConnectionString)
                Console.WriteLine("CreationName:            {0}", connMgr.CreationName)
                Console.WriteLine("DelayValidation:         {0}", connMgr.DelayValidation)
                Console.WriteLine("Description:             {0}", connMgr.Description)
                Console.WriteLine("HostType:                {0}", connMgr.HostType)
                Console.WriteLine("ID:                      {0}", connMgr.ID)
                Console.WriteLine("InnerObject:             {0}", connMgr.InnerObject)
                Console.WriteLine("Name:                    {0}", connMgr.Name)
                Console.WriteLine("ProtectionLevel:         {0}", connMgr.ProtectionLevel)
                Console.WriteLine("SupportsDTCTransactions: {0}", connMgr.SupportsDTCTransactions)
            Next
            Console.WriteLine("")
        End Sub
    End Class
End Namespace

Sample Output:

The number of connections in the package is: 2

ConnectionString: Data Source=localhost;Initial Catalog=AdventureWorks;Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Auto Translate=False;

CreationName: OLEDB

DelayValidation: False

Description:

HostType: ConnectionManager

ID: {3427BFE1-F10C-4B7E-8E70-E8D9DC7DDBA3}

InnerObject: System.__ComObject

Name: localhost.AdventureWorks

ProtectionLevel: EncryptSensitiveWithUserKey

SupportsDTCTransactions: True

ConnectionString: C:\Program Files\Microsoft SQL Server\100\Samples\Integration Services\Package Samples\CalculatedColumns Sample\CalculatedColumns\results.txt

CreationName: FLATFILE

DelayValidation: False

Description:

HostType: ConnectionManager

ID: {48B66F8D-7DFE-4D85-91C7-0999655484B2}

InnerObject: System.__ComObject

Name: Transaction Summary by Product1

ProtectionLevel: EncryptSensitiveWithUserKey

SupportsDTCTransactions: False

Community Additions

ADD
Show:
© 2015 Microsoft