Developing a Custom ForEach Enumerator

新建日期: 2006 年 4 月 14 日

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 ForEachDirectory 示例.

In This Section

This section describes how to create, configure, and code a custom foreach enumerator and its custom user interface.

Topic Description

Creating a Custom Foreach Enumerator

Describes how to create the classes for a custom foreach enumerator project.

Coding a Custom Foreach Enumerator

Describes how to implement a custom foreach enumerator by overriding the methods and properties of the base class.

Developing a User Interface for a Custom ForEach Enumerator

Describes how to implement the user interface class and the form that is used to configure the custom foreach enumerator.

For information that is common to all the type of custom objects that you can create in Integration Services, see the following topics.

Topic Description

Developing Custom Objects for Integration Services

Describes the basic steps in implementing all types of custom objects for Integration Services.

Persisting Custom Objects

Describes custom persistence and explains when it is necessary.

Building, Deploying, and Debugging Custom Objects

Describes the techniques for building, signing, deploying, and debugging custom objects.

For information on the other types of custom objects that you can create in Integration Services, see the following topics.

Topic Description

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.

请参阅

概念

编程示例

帮助和信息

获取 SQL Server 2005 帮助