ForEachADOEnumerator Class

Definition

Enumerates over rows in a dataset, data table, or recordset. This class cannot be inherited.

public ref class ForEachADOEnumerator sealed : Microsoft::SqlServer::Dts::Runtime::ForEachEnumerator, Microsoft::SqlServer::Dts::Runtime::Enumerators::ADO::IDTSForEachADOEnumerator, Microsoft::SqlServer::Dts::Runtime::IDTSComponentPersist
[Microsoft.SqlServer.Dts.Runtime.DtsForEachEnumerator(LocalizationType=typeof(Microsoft.SqlServer.Dts.Runtime.Enumerators.ADO.Localized), UITypeName="Microsoft.SqlServer.Dts.Runtime.Enumerators.ADO.ForEachADOEnumeratorUI, Microsoft.SqlServer.ForEachADOEnumeratorUI, Version={0}, Culture=Neutral, PublicKeyToken=89845dcd8080cc91")]
public sealed class ForEachADOEnumerator : Microsoft.SqlServer.Dts.Runtime.ForEachEnumerator, Microsoft.SqlServer.Dts.Runtime.Enumerators.ADO.IDTSForEachADOEnumerator, Microsoft.SqlServer.Dts.Runtime.IDTSComponentPersist
[<Microsoft.SqlServer.Dts.Runtime.DtsForEachEnumerator(LocalizationType=typeof(Microsoft.SqlServer.Dts.Runtime.Enumerators.ADO.Localized), UITypeName="Microsoft.SqlServer.Dts.Runtime.Enumerators.ADO.ForEachADOEnumeratorUI, Microsoft.SqlServer.ForEachADOEnumeratorUI, Version={0}, Culture=Neutral, PublicKeyToken=89845dcd8080cc91")>]
type ForEachADOEnumerator = class
    inherit ForEachEnumerator
    interface IDTSForEachADOEnumerator
    interface IDTSComponentPersist
Public NotInheritable Class ForEachADOEnumerator
Inherits ForEachEnumerator
Implements IDTSComponentPersist, IDTSForEachADOEnumerator
Inheritance
ForEachADOEnumerator
Attributes
Implements

Constructors

ForEachADOEnumerator()

Initializes a new instance of the ForEachADOEnumerator class.

Properties

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)
DataObjectVariable

Gets or sets a String that contains the persisted data object from the enumerator.

TargetServerVersion (Inherited from ForEachEnumerator)
Type

Gets or sets a value that indicates what type of object to enumerate over.

Version

Returns the version number of the package. This property is read-only.

(Inherited from ForEachEnumerator)

Methods

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 IEnumerator interface that can iterate over the ActiveX Data Objects (ADO) object.

GetHashCode()

Returns the hash code for this instance.

(Inherited from DtsObject)
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 that is saved as .xml to the hard drive, use the LoadPackage(String, IDTSEvents) method.

SaveToXML(XmlDocument, IDTSInfoEvents)

This method is not callable by your application code. To save a package as .xml, use the SaveToXml(String, Package, IDTSEvents) method.

Update(String)

This method updates the old package XML with the new package XML if CanUpdate(String) 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)

Applies to