Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

ConnectionManager.Properties Property

Gets a collection of property objects for the ConnectionManager. This is the method of accessing the properties of the specific connection that is being hosted by the connection manager. This property is read-only.

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

public DtsProperties Properties { get; }
/** @property */
public final DtsProperties get_Properties ()

public final function get Properties () : DtsProperties

Property Value

A DtsProperties collection that contains the properties specific to that connection type.

All classes that inherit from the ConnectionManager contain the same properties and methods. However, each connection type has additional properties that are specific to that connection type. When you obtain a connection manager from the collection and iterate through the properties, all properties that are not found in the ConnectionManager class are properties that are specific to that connection. To set a property that is unique to the connection, but is not part of the ConnectionManager, such as the RetainSameConnection property found on several connections, use the following line of code:

ConnectionManager.Properties("RetainSameConnection") = True

For more information about the type of connections available, see Connection Managers.

The following code example obtains the Properties collection from the first connection manager in the Connections collection using the index syntax of [0]. The sample then writes the names of the properties found in the Properties collection.

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

namespace ConnMgr_Properties_Collection
    class Program
        static void Main(string[] args)
            // The package is one of the SSIS Samples.
            string mySample = @"C:\Program Files\Microsoft SQL Server\90\Samples\Integration Services\Package Samples\CalculatedColumns Sample\CalculatedColumns\CalculatedColumns.dtsx";

            // Create an application and load the sample.
            Application app = new Application();
            Package pkg = app.LoadPackage(mySample, null);
            Connections myConns = pkg.Connections;

            // Get the Properties collection from the connection
            // manager and iterate through the properties, 
            // printing the property names.
            ConnectionManager myConnMgr = myConns[0];
            DtsProperties connProperties = myConnMgr.Properties;

            foreach (DtsProperty connProp in connProperties)

Sample Output:













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.

Development Platforms

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

Target Platforms

Community Additions

© 2015 Microsoft