DtsForEachEnumeratorAttribute Class
Supplies design-time information about a ForEachEnumerator object. This class cannot be inherited.
Assembly: Microsoft.SqlServer.ManagedDTS (in Microsoft.SqlServer.ManagedDTS.dll)
System::Attribute
Microsoft.SqlServer.Dts.Runtime.Localization::DtsLocalizableAttribute
Microsoft.SqlServer.Dts.Runtime::DtsForEachEnumeratorAttribute
| Name | Description | |
|---|---|---|
![]() | DtsForEachEnumeratorAttribute() | Initializes a new instance of the DtsForEachEnumeratorAttribute. |
| Name | Description | |
|---|---|---|
![]() | Description | This API supports the product infrastructure and is not intended to be used directly from your code. Gets or sets the description of the DtsLocalizableAttribute.(Inherited from DtsLocalizableAttribute.) |
![]() | DisplayName | This API supports the product infrastructure and is not intended to be used directly from your code. Gets or sets the display name of the DtsLocalizableAttribute.(Inherited from DtsLocalizableAttribute.) |
![]() | ForEachEnumeratorContact | Gets or sets the contact information for the Foreach enumerator object. |
![]() | LocalizationType | This API supports the product infrastructure and is not intended to be used directly from your code. Gets or sets the class that supplies values for the DtsLocalizableAttribute.(Inherited from DtsLocalizableAttribute.) |
![]() | TypeId | (Inherited from Attribute.) |
![]() | UITypeName | Gets or sets the user interface for the Foreach enumerator object. |
| Name | Description | |
|---|---|---|
![]() | Equals(Object^) | (Inherited from Attribute.) |
![]() | GetHashCode() | (Inherited from Attribute.) |
![]() | GetType() | (Inherited from Object.) |
![]() | IsDefaultAttribute() | (Inherited from Attribute.) |
![]() | Match(Object^) | (Inherited from Attribute.) |
![]() | ToString() | (Inherited from Object.) |
| Name | Description | |
|---|---|---|
![]() ![]() | _Attribute::GetIDsOfNames(Guid%, IntPtr, UInt32, UInt32, IntPtr) | (Inherited from Attribute.) |
![]() ![]() | _Attribute::GetTypeInfo(UInt32, UInt32, IntPtr) | (Inherited from Attribute.) |
![]() ![]() | _Attribute::GetTypeInfoCount(UInt32%) | (Inherited from Attribute.) |
![]() ![]() | _Attribute::Invoke(UInt32, Guid%, UInt32, Int16, IntPtr, IntPtr, IntPtr, IntPtr) | (Inherited from Attribute.) |
This attribute is applied to all managed Foreach enumerator classes and identifies the class as a managed Foreach enumerator to the SQL Server (SSIS) run-time engine. This attribute provides information through its properties to control how the designer displays and interacts with the object. Because all managed enumerators derive from the ForEachEnumerator base class, the first step when creating a custom enumerator is to create a class library project and inherit from the base class. Next, apply the DtsForEachEnumeratorAttribute to the class. This attribute provides the name, description, and user interface design-time information to the designer. The UITypeName property identifies the Type that implements the user interface for the enumerator that is displayed in the ForEachLoop editor. The DisplayName property is displayed in the Toolbox in the SQL Server SQL Server Data Tools (SSDT).
For more information about applying attributes to a class, see "Applying Attributes" in the .NET Framework Developer's Guide.
The attribute is formatted as a comma-delimited string, which can contain the following elements from the Attributes class, in addition to the other attributes declared on the DtsForEachEnumeratorAttribute, such as the UITypeName and the ForEachEnumeratorContact:
Type name
Assembly name
File version
Culture
Public key token
The following string gives an example of how the string is formatted.
[DtsForEachEnumerator(DisplayName="MyEnumerator",UITypeName="MyNamespace.MyEnumeratorClassName,MyAssemblyName",Version="1.00.000.00",Culture="neutral",PublicKeyToken="")]
You can find the values of the Culture and PublicKeyToken parameters in your assembly by examining the properties of the assembly in the global assembly cache (GAC).
The following code sample shows the attribute applied to a new class, with several properties defined, including the DisplayName, Description, ForEachEnumeratorContact, and UITypeName.
Any public static ( Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.



