This topic has not yet been rated - Rate this topic

DtsConnectionAttribute Class

SQL Server 2008

Supplies design time information about a ConnectionManager object.

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

Syntax

C++

JScript

[AttributeUsageAttribute(AttributeTargets.Class, Inherited = false, AllowMultiple = false)]
public sealed class DtsConnectionAttribute : DtsLocalizableAttribute

Remarks

This attribute is applied to managed Integration Services connection managers that are derived from ConnectionManagerBase. The attribute identifies a class as a managed connection manager and provides information through its properties that control how the SSIS Designer displays and interacts with the object.

The DisplayName and ConnectionType properties are required properties. The DisplayName is displayed in the list of connection managers in Business Intelligence Development Studio.

Examples

The following example shows a class that implements this attribute.

  [DtsConnection(DisplayName = "MyConnectionManager",
    Description = "Custom Connection Manager for Testing",
    IconResource = "MyConnectionManager.MyConnectionMgrIcon.ico",
    UITypeName = "MyNamespace.MyConnectionManagerClassName," +
    "MyAssemblyName,Version=1.0.0.0,Culture=neutral," +
    "PublicKeyToken=<value>")]
public class MyConnnectionMgr : ConnectionManagerBase
{
}

Inheritance Hierarchy

System.Object
  System.Attribute
    Microsoft.SqlServer.Dts.Runtime.Localization.DtsLocalizableAttribute
      Microsoft.SqlServer.Dts.Runtime.DtsConnectionAttribute

Thread Safety

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

Reference

DtsConnectionAttribute Members

Microsoft.SqlServer.Dts.Runtime Namespace

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD