DtsConnectionAttribute Class

Supplies design time information about a ConnectionManager object.

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

Syntax

'Declaration
<AttributeUsageAttribute(AttributeTargets.Class, Inherited:=False, AllowMultiple:=False)> _
Public NotInheritable Class DtsConnectionAttribute
    Inherits DtsLocalizableAttribute

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

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

/** @attribute AttributeUsageAttribute(AttributeTargets.Class, Inherited=false, AllowMultiple=false) */ 
public final class DtsConnectionAttribute extends DtsLocalizableAttribute

AttributeUsageAttribute(AttributeTargets.Class, Inherited=false, AllowMultiple=false) 
public final class DtsConnectionAttribute extends DtsLocalizableAttribute

Remarks

Updated sample code:15 September 2007

Updated text:14 April 2006

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.

Inheritance Hierarchy

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

Example

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.00.000.00,Culture=neutral,PublicKeyToken=")] 
public class MyConnnectionMgr : ConnectionManagerBase
{
}

<DtsConnection(DisplayName:="MyConnectionManager", _
  Description:="Custom Connection Manager for Testing", _
  IconResource:="MyConnectionManager.MyConnectionMgrIcon.ico", _
  UITypeName:="MyNamespace.MyConnectionManagerClassName,MyAssemblyName," & _
  "Version=1.00.000.00,Culture=neutral,PublicKeyToken=")> _
Public Class MyConnnectionMgr
     Inherits ConnectionManagerBase
End Class

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

DtsConnectionAttribute Members
Microsoft.SqlServer.Dts.Runtime Namespace

Change History