ForEachFromVarEnumerator Class

Article
12/03/2008

This enumerator is used to loop over the objects that are in the variable specified in VariableName.

Namespace: Microsoft.SqlServer.Dts.Runtime.Enumerators.FromVar
Assembly: Microsoft.SqlServer.ForEachFromVarEnumerator (in microsoft.sqlserver.foreachfromvarenumerator.dll)

Syntax

'Declaration
Public NotInheritable Class ForEachFromVarEnumerator
    Inherits ForEachEnumerator
    Implements IDTSComponentPersist, IDTSForEachFromVarEnumerator

public sealed class ForEachFromVarEnumerator : ForEachEnumerator, IDTSComponentPersist, IDTSForEachFromVarEnumerator

public ref class ForEachFromVarEnumerator sealed : public ForEachEnumerator, IDTSComponentPersist, IDTSForEachFromVarEnumerator

public final class ForEachFromVarEnumerator extends ForEachEnumerator implements IDTSComponentPersist, IDTSForEachFromVarEnumerator

public final class ForEachFromVarEnumerator extends ForEachEnumerator implements IDTSComponentPersist, IDTSForEachFromVarEnumerator

Remarks

New:14 April 2006

An example of the use of this enumerator is when a query is run, and the result of the query is stored in the variable. You can use this enumerator to loop over the query results.

Inheritance Hierarchy

System.Object
   Microsoft.SqlServer.Dts.Runtime.DtsObject
     Microsoft.SqlServer.Dts.Runtime.ForEachEnumerator
      Microsoft.SqlServer.Dts.Runtime.Enumerators.FromVar.ForEachFromVarEnumerator

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