• Article

IDtsConnectionService.CreateConnection Method (String)

Creates a new connection using the connection type specified as a parameter.

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

Syntax

'Declaration
Function CreateConnection ( _
    connectionType As String _
) As ArrayList
'Usage
Dim instance As IDtsConnectionService
Dim connectionType As String
Dim returnValue As ArrayList

returnValue = instance.CreateConnection(connectionType)

ArrayList CreateConnection(
    string connectionType
)

ArrayList^ CreateConnection(
    String^ connectionType
)

abstract CreateConnection : 
        connectionType:string -> ArrayList 

function CreateConnection(
    connectionType : String
) : ArrayList

Parameters

  • connectionType
    Type: System.String
    The type of connection you want to put in the array.

Return Value

Type: System.Collections.ArrayList
An ArrayList containing the collection of connections created. An empty collection is returned if an error occurs or if the user cancels the request.

Remarks

The implementation code can be written to provide a list of connections in the user interface for user convenience.

Examples

The following code example shows how to get the list of connection types when the service is a file connection.

// Service is a connection service.
IDtsConnectionService dtsConnectionService = 
    serviceProvider.GetService(typeof(IDtsConnectionService)) as 
    IDtsConnectionService;
ArrayList list = dtsConnectionService.CreateConnection(connectionType);
ConnectionManager cMgr = (ConnectionManager)list[0];