ForEachFromVarEnumerator 类

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

继承层次结构

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

命名空间:  Microsoft.SqlServer.Dts.Runtime.Enumerators.FromVar
程序集:  Microsoft.SqlServer.ForEachFromVarEnumerator(在 Microsoft.SqlServer.ForEachFromVarEnumerator.dll 中)

语法

声明
Public NotInheritable Class ForEachFromVarEnumerator _
    Inherits ForEachEnumerator _
    Implements IDTSComponentPersist, IDTSForEachFromVarEnumerator
用法
Dim instance As ForEachFromVarEnumerator
public sealed class ForEachFromVarEnumerator : ForEachEnumerator, 
    IDTSComponentPersist, IDTSForEachFromVarEnumerator
public ref class ForEachFromVarEnumerator sealed : public ForEachEnumerator, 
    IDTSComponentPersist, IDTSForEachFromVarEnumerator
[<SealedAttribute>]
type ForEachFromVarEnumerator =  
    class
        inherit ForEachEnumerator
        interface IDTSComponentPersist
        interface IDTSForEachFromVarEnumerator
    end
public final class ForEachFromVarEnumerator extends ForEachEnumerator implements IDTSComponentPersist, IDTSForEachFromVarEnumerator

ForEachFromVarEnumerator 类型公开以下成员。

构造函数

  名称 说明
公共方法 ForEachFromVarEnumerator Initializes a new instance of the ForEachFromVarEnumerator class.

页首

属性

  名称 说明
公共属性 CollectionEnumerator Gets or sets Boolean that indicates if the foreach loop enumerator is enumerating collections of objects or enumerating collections of collections. (从 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. (从 ForEachEnumerator 继承。)

页首

方法

  名称 说明
公共方法 CanUpdate A Boolean that indicates if the new package XML can update the old package XML. (从 ForEachEnumerator 继承。)
公共方法 Equals Determines whether two object instances are equal. (从 DtsObject 继承。)
受保护方法 Finalize (从 Object 继承。)
公共方法 GetEnumerator Returns an enumerator that can iterate over the ForEachFromVarEnumerator instance. (覆盖 ForEachEnumerator. . :: . .GetEnumerator(Connections, VariableDispenser, IDTSInfoEvents, IDTSLogging)。)
公共方法 GetHashCode Returns the hash code for this instance. (从 DtsObject 继承。)
公共方法 GetType (从 Object 继承。)
公共方法 InitializeForEachEnumerator Initializes the properties associated with the task. This method is called by the runtime and is not used in code. (从 ForEachEnumerator 继承。)
公共方法 LoadFromXML This method is not callable by your application code. To load a package saved as .xml, use the Application..::..LoadPackage method.
受保护方法 MemberwiseClone (从 Object 继承。)
公共方法 SaveToXML This method is not callable by your application code. To save a package as .xml, use the Application..::..SaveToXml method.
公共方法 ToString (从 Object 继承。)
公共方法 Update This method updates the old package XML with the new package XML if CanUpdate is set to true. (从 ForEachEnumerator 继承。)
公共方法 Validate Allows the container to determine if it contains invalid settings that will prevent it from executing successfully. (从 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.

线程安全

此类型的任何公共 static(在 Visual Basic 中为 Shared) 成员都是线程安全的。不保证所有实例成员都是线程安全的。