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) 成員都是執行緒安全的。並不是所有的執行個體成員都保證可以用於所有的執行緒。

請參閱

參考

Microsoft.SqlServer.Dts.Runtime.Enumerators.FromVar 命名空間