ForEachLoop Class

Article
12/03/2008

Provides a container that defines an iterative workflow in a package using the foreach iteration statement.

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

Syntax

'Declaration
Public NotInheritable Class ForEachLoop
    Inherits EventsProvider
    Implements IDTSSequence, IDTSPropertiesProvider, IDTSPackagePath

public sealed class ForEachLoop : EventsProvider, IDTSSequence, IDTSPropertiesProvider, IDTSPackagePath

public ref class ForEachLoop sealed : public EventsProvider, IDTSSequence, IDTSPropertiesProvider, IDTSPackagePath

public final class ForEachLoop extends EventsProvider implements IDTSSequence, IDTSPropertiesProvider, 
    IDTSPackagePath

public final class ForEachLoop extends EventsProvider implements IDTSSequence, IDTSPropertiesProvider, 
    IDTSPackagePath

Remarks

At run time, the control flow in the ForEachLoop container is repeated within the overall package control flow.

Inheritance Hierarchy

System.Object
   Microsoft.SqlServer.Dts.Runtime.DtsObject
     Microsoft.SqlServer.Dts.Runtime.Executable
       Microsoft.SqlServer.Dts.Runtime.DtsContainer
         Microsoft.SqlServer.Dts.Runtime.EventsProvider
          Microsoft.SqlServer.Dts.Runtime.ForEachLoop

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.

Share via