Udostępnij za pośrednictwem


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

Release

History

15 September 2007

Changed content:
  • Corrected code examples.

14 April 2006

New content:
  • Added text stating that the ConnectionType property is required. It is required for the attribute to be valid and usable by SSIS.