Export (0) Print
Expand All

ForEachSchemaRowsetEnumerator Class

Contains the methods and properties for implementing a Foreach loop that enumerates over a schema rowset. This class cannot be inherited.

Object
  Microsoft.SqlServer.Dts.Runtime.DtsObject
    Microsoft.SqlServer.Dts.Runtime.ForEachEnumerator
      Microsoft.SqlServer.Dts.Runtime.Enumerators.ADO.ForEachSchemaRowsetEnumerator

Namespace:  Microsoft.SqlServer.Dts.Runtime.Enumerators.ADO
Assembly:  Microsoft.SqlServer.ForEachADOEnumerator (in Microsoft.SqlServer.ForEachADOEnumerator.dll)

[<SealedAttribute>]
[<DtsForEachEnumeratorAttribute(LocalizationType = typeof(ForEachSchemaRowsetEnumerator), UITypeName = "Microsoft.SqlServer.Dts.Runtime.Enumerators.ADO.ForEachSchemaRowsetEnumeratorUI, Microsoft.SqlServer.ForEachADOEnumeratorUI, Version={0}, Culture=Neutral, PublicKeyToken=89845dcd8080cc91")>]
type ForEachSchemaRowsetEnumerator =  
    class 
        inherit ForEachEnumerator 
        interface IDTSForEachSchemaRowsetEnumerator 
        interface IDTSComponentPersist 
    end

The ForEachSchemaRowsetEnumerator type exposes the following members.

  NameDescription
Public methodForEachSchemaRowsetEnumeratorInitializes a new instance of the ForEachSchemaRowsetEnumerator class.
Top

  NameDescription
Public propertyCollectionEnumeratorGets or sets Boolean that indicates if the foreach loop enumerator is enumerating collections of objects or enumerating collections of collections. (Inherited from ForEachEnumerator.)
Public propertyConnectionGets or sets a String that contains the connection information for the schema rowset enumerator.
Public propertyStatic memberForEachEnumeratorDescriptionReturns a description for the ForEachSchemaRowsetEnumerator.
Public propertyStatic memberForEachEnumeratorDisplayNameGets or sets a String that contains the display name for the enumerator.
Public propertyRestrictionsGets or sets an array of Strings that contains the restrictions to apply to the rowset that is returned.
Public propertySchemaRowsetGets or sets the GUID of the schema
Public propertyVersionReturns the version number of the package. This property is read-only. (Inherited from ForEachEnumerator.)
Top

  NameDescription
Public methodCanUpdateA Boolean that indicates if the new package XML can update the old package XML. (Inherited from ForEachEnumerator.)
Public methodEqualsDetermines whether two object instances are equal. (Inherited from DtsObject.)
Public methodGetEnumeratorReturns an enumerator for iterating over the collection. (Overrides ForEachEnumerator.GetEnumerator(Connections, VariableDispenser, IDTSInfoEvents, IDTSLogging).)
Public methodGetHashCodeReturns the hash code for this instance. (Inherited from DtsObject.)
Public methodGetType (Inherited from Object.)
Public methodInitializeForEachEnumeratorInitializes the properties associated with the task. This method is called by the runtime and is not used in code. (Inherited from ForEachEnumerator.)
Public methodLoadFromXMLThis method is not callable by your application code. To load a package saved as .xml, use the Application.LoadPackage method.
Public methodSaveToXMLThis method is not callable by your application code. To save a package as .xml, use the Application.SaveToXml method.
Public methodToString (Inherited from Object.)
Public methodUpdateThis method updates the old package XML with the new package XML if CanUpdate is set to true. (Inherited from ForEachEnumerator.)
Public methodValidateAllows the container to determine if it contains invalid settings that will prevent it from executing successfully. (Inherited from ForEachEnumerator.)
Top

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Community Additions

ADD
Show:
© 2014 Microsoft