ConnectionInfo.ConnectionContact Property

Represents a writer-defined String. This value is read-only.

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

Syntax

'Declaration
Public ReadOnly Property ConnectionContact As String

public string ConnectionContact { get; }

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

/** @property */
public String get_ConnectionContact ()

public function get ConnectionContact () : String

Property Value

A String that contains information put in by the developer. The value typically contains the contact information for the connection.

Example

The following code example creates an Application object, and then iterates through the default connections on the computer and lists the properties of each connection. In this example, the ConnectionContact is shown as "Microsoft Corporation".

using System;
using System.Collections.Generic;
using System.Text;
using Microsoft.SqlServer.Dts.Runtime;

namespace ConnInfoTest
{
    class Program
    {
        static void Main(string[] args)
        {
            Application dtsApplication = new Application();
            ConnectionInfos connectionInfos = dtsApplication.ConnectionInfos;

            foreach (ConnectionInfo connInfo in connectionInfos)
            {
                Console.WriteLine(connInfo.ConnectionContact);
                Console.WriteLine(connInfo.ConnectionType);
                Console.WriteLine(connInfo.CreationName);
                Console.WriteLine(connInfo.Description);
                Console.WriteLine(connInfo.FileName);
                Console.WriteLine(connInfo.FileNameVersionString);
                Console.WriteLine(connInfo.IconFile);
                Console.WriteLine(connInfo.IconResource);
                Console.WriteLine(connInfo.ID);
                Console.WriteLine(connInfo.Name);
                Console.WriteLine(connInfo.UITypeName);
            }
        }
    }
}

Imports System
Imports System.Collections.Generic
Imports System.Text
Imports Microsoft.SqlServer.Dts.Runtime
 
Namespace ConnInfoTest
    Class Program
        Shared  Sub Main(ByVal args() As String)
            Dim dtsApplication As Application =  New Application() 
            Dim connectionInfos As ConnectionInfos =  dtsApplication.ConnectionInfos 
 
            Dim connInfo As ConnectionInfo
            For Each connInfo In connectionInfos
                Console.WriteLine(connInfo.ConnectionContact)
                Console.WriteLine(connInfo.ConnectionType)
                Console.WriteLine(connInfo.CreationName)
                Console.WriteLine(connInfo.Description)
                Console.WriteLine(connInfo.FileName)
                Console.WriteLine(connInfo.FileNameVersionString)
                Console.WriteLine(connInfo.IconFile)
                Console.WriteLine(connInfo.IconResource)
                Console.WriteLine(connInfo.ID)
                Console.WriteLine(connInfo.Name)
                Console.WriteLine(connInfo.UITypeName)
            Next
        End Sub
    End Class
End Namespace

Sample Output:

Microsoft Corporation

FILE

DTS.ConnectionManagerFile.1

Connection Manager for Files

C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DtsConn.dll

2000.90.1049.0

C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DtsConn.dll

0

{41F5EFE4-E91A-4EB0-BF10-D40FD48B3C03}

DTS Connection Manager for Files

Microsoft.DataTransformationServices.Design.SingleFileConnectionManagerUI,

Microsoft.DataTransformationServices.Design, Version=9.0.242.0,

Culture=neutral, PublicKeyToken=89845dcd8080cc91

Thread Safety

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Platforms

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

See Also

Reference

ConnectionInfo Class
ConnectionInfo Members
Microsoft.SqlServer.Dts.Runtime Namespace