ForEachFromVarEnumerator Class
This enumerator is used to loop over the objects that are in the variable specified in VariableName.
Assembly: Microsoft.SqlServer.ForEachFromVarEnumerator (in Microsoft.SqlServer.ForEachFromVarEnumerator.dll)
Microsoft.SqlServer.Dts.Runtime::DtsObject
Microsoft.SqlServer.Dts.Runtime::ForEachEnumerator
Microsoft.SqlServer.Dts.Runtime.Enumerators.FromVar::ForEachFromVarEnumerator
| Name | Description | |
|---|---|---|
![]() | ForEachFromVarEnumerator() | Initializes a new instance of the ForEachFromVarEnumerator class. |
| Name | Description | |
|---|---|---|
![]() | CollectionEnumerator | Gets or sets Boolean that indicates if the foreach loop enumerator is enumerating collections of objects or enumerating collections of collections.(Inherited from ForEachEnumerator.) |
![]() | TargetServerVersion | (Inherited from ForEachEnumerator.) |
![]() | VariableName | Gets or sets the name of the variable to enumerate. |
![]() | Version | Returns the version number of the package. This property is read-only. (Inherited from ForEachEnumerator.) |
| Name | Description | |
|---|---|---|
![]() | CanUpdate(String^) | A Boolean that indicates if the new package XML can update the old package XML.(Inherited from ForEachEnumerator.) |
![]() | Equals(Object^) | Determines whether two object instances are equal.(Inherited from DtsObject.) |
![]() | GetEnumerator(Connections^, VariableDispenser^, IDTSInfoEvents^, IDTSLogging^) | Returns an enumerator that can iterate over the ForEachFromVarEnumerator instance.(Overrides ForEachEnumerator::GetEnumerator(Connections^, VariableDispenser^, IDTSInfoEvents^, IDTSLogging^).) |
![]() | GetHashCode() | Returns the hash code for this instance.(Inherited from DtsObject.) |
![]() | GetType() | (Inherited from Object.) |
![]() | InitializeForEachEnumerator(Connections^, IDTSInfoEvents^, ObjectReferenceTracker^) | Initializes the properties associated with the task. This method is called by the runtime and is not used in code.(Inherited from ForEachEnumerator.) |
![]() | LoadFromXML(XmlElement^, IDTSInfoEvents^) | This method is not callable by your application code. To load a package saved as .xml, use the Application::LoadPackage method. |
![]() | SaveToXML(XmlDocument^, IDTSInfoEvents^) | This method is not callable by your application code. To save a package as .xml, use the Application::SaveToXml method. |
![]() | ToString() | (Inherited from Object.) |
![]() | Update(String^%) | This method updates the old package XML with the new package XML if CanUpdate is set to true.(Inherited from ForEachEnumerator.) |
![]() | Validate(Connections^, VariableDispenser^, IDTSInfoEvents^, IDTSLogging^) | Allows the container to determine if it contains invalid settings that will prevent it from executing successfully.(Inherited from ForEachEnumerator.) |
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.
Any public static ( Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

