• Article

DtsProperty.ConnectionType Property

Returns the name of the connection manager used to create the connection. This field is read-only.

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

Syntax

'Declaration
Public ReadOnly Property ConnectionType As String
    Get
'Usage
Dim instance As DtsProperty
Dim value As String

value = instance.ConnectionType

public string ConnectionType { get; }

public:
property String^ ConnectionType {
    String^ get ();
}

member ConnectionType : string

function get ConnectionType () : String

Property Value

Type: System.String
A String that contains the name of the connection manager used to create the connection. nulla null reference (Nothing in Visual Basic) if the object is not a connection manager.

Remarks

A partial list of connection manager types included with Integration Services (SSIS)are:

  • ADO, the connection manager for ActiveX Data Objects (ADO)

  • ADO.NET, the connection manager for ADO.NET

  • FILE, the connection manager for files

For a complete list of connection managers included with SSIS and their associated names, see Adding Connections Programmatically.