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

DtsConnectionAttribute Class

Supplies design time information about a ConnectionManager object.


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

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

The DtsConnectionAttribute type exposes the following members.

Public methodDtsConnectionAttributeInitializes a new instance of the DtsConnectionAttribute class.

Public propertyConnectionContactGets or sets a String that contains the contact information for the connection manager.
Public propertyConnectionTypeGets or sets the type of the connection manager. This property is required.
Public propertyDescriptionInfrastructure. Gets or sets the description of the DtsLocalizableAttribute. (Inherited from DtsLocalizableAttribute.)
Public propertyDisplayNameInfrastructure. Gets or sets the display name of the DtsLocalizableAttribute. (Inherited from DtsLocalizableAttribute.)
Public propertyIconResourceGets or sets the icon associated with the connection manager object.
Public propertyLocalizationTypeInfrastructure. Gets or sets the class that supplies values for the DtsLocalizableAttribute. (Inherited from DtsLocalizableAttribute.)
Public propertyTypeId (Inherited from Attribute.)
Public propertyUITypeNameSpecifies the qualified name of the assembly that implements the user interface of the connection manager.

Public methodEquals (Inherited from Attribute.)
Public methodGetHashCode (Inherited from Attribute.)
Public methodGetType (Inherited from Object.)
Public methodIsDefaultAttribute (Inherited from Attribute.)
Public methodMatch (Inherited from Attribute.)
Public methodToString (Inherited from Object.)

Explicit interface implemetationPrivate methodSystem#Runtime#InteropServices#_Attribute#GetIDsOfNames (Inherited from Attribute.)
Explicit interface implemetationPrivate methodSystem#Runtime#InteropServices#_Attribute#GetTypeInfo (Inherited from Attribute.)
Explicit interface implemetationPrivate methodSystem#Runtime#InteropServices#_Attribute#GetTypeInfoCount (Inherited from Attribute.)
Explicit interface implemetationPrivate methodSystem#Runtime#InteropServices#_Attribute#Invoke (Inherited from Attribute.)

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 SQL Server Data Tools (SSDT).

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," +
public class MyConnnectionMgr : ConnectionManagerBase

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

Community Additions

© 2015 Microsoft