Integration Services uses foreach enumerators to iterate over the items in a collection and perform the same tasks for each element. Integration Services includes a variety of foreach enumerators that support the most commonly used collections, such as all the files in a folder, all the tables in a database, or all the elements of a list stored in a package variable. If the foreach enumerators and collections that are provided do not entirely meet your requirements, you can create a custom foreach enumerator.
To create a custom foreach enumerator, you have to create a class that inherits from the ForEachEnumerator base class, apply the DtsForEachEnumeratorAttribute attribute to your new class, and override the important methods and properties of the base class, including the GetEnumerator method.
For a working sample of a custom foreach enumerator, see the Readme_ForEachDirectory Sample.
In This Section
Related Topics
Information Common to all Custom Objects
Information about Other Custom Objects
For information on the other types of custom objects that you can create in Integration Services, see the following topics:
-
Developing a Custom Task
-
Discusses how to program custom tasks.
-
Developing a Custom Connection Manager
-
Discusses how to program custom connection managers.
-
Developing a Custom Log Provider
-
Discusses how to program custom log providers.
-
Developing a Custom Data Flow Component
-
Discusses how to program custom data flow sources, transformations, and destinations.
-
.gif)
Stay Up to Date with Integration Services
-
For the latest downloads, articles, samples, and videos from Microsoft, as well as selected solutions from the community, visit the Integration Services page on MSDN or TechNet:
For automatic notification of these updates, subscribe to the RSS feeds available on the page.
|
See Also