Clase ForEachFromVarEnumerator
This enumerator is used to loop over the objects that are in the variable specified in VariableName.
Jerarquía de herencia
System.Object
Microsoft.SqlServer.Dts.Runtime.DtsObject
Microsoft.SqlServer.Dts.Runtime.ForEachEnumerator
Microsoft.SqlServer.Dts.Runtime.Enumerators.FromVar.ForEachFromVarEnumerator
Espacio de nombres: Microsoft.SqlServer.Dts.Runtime.Enumerators.FromVar
Ensamblado: Microsoft.SqlServer.ForEachFromVarEnumerator (en Microsoft.SqlServer.ForEachFromVarEnumerator.dll)
Sintaxis
'Declaración
Public NotInheritable Class ForEachFromVarEnumerator _
Inherits ForEachEnumerator _
Implements IDTSComponentPersist, IDTSForEachFromVarEnumerator
'Uso
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
El tipo ForEachFromVarEnumerator expone los siguientes miembros.
Constructores
Nombre | Descripción | |
---|---|---|
![]() |
ForEachFromVarEnumerator | Initializes a new instance of the ForEachFromVarEnumerator class. |
Arriba
Propiedades
Nombre | Descripción | |
---|---|---|
![]() |
CollectionEnumerator | Gets or sets Boolean that indicates if the foreach loop enumerator is enumerating collections of objects or enumerating collections of collections. (Se hereda de 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. (Se hereda de ForEachEnumerator.) |
Arriba
Métodos
Nombre | Descripción | |
---|---|---|
![]() |
CanUpdate | A Boolean that indicates if the new package XML can update the old package XML. (Se hereda de ForEachEnumerator.) |
![]() |
Equals | Determines whether two object instances are equal. (Se hereda de DtsObject.) |
![]() |
GetEnumerator | Returns an enumerator that can iterate over the ForEachFromVarEnumerator instance. (Invalida ForEachEnumerator.GetEnumerator(Connections, VariableDispenser, IDTSInfoEvents, IDTSLogging).) |
![]() |
GetHashCode | Returns the hash code for this instance. (Se hereda de DtsObject.) |
![]() |
GetType | (Se hereda de Object.) |
![]() |
InitializeForEachEnumerator | Initializes the properties associated with the task. This method is called by the runtime and is not used in code. (Se hereda de ForEachEnumerator.) |
![]() |
LoadFromXML | This method is not callable by your application code. To load a package saved as .xml, use the Application.LoadPackage method. |
![]() |
SaveToXML | This method is not callable by your application code. To save a package as .xml, use the Application.SaveToXml method. |
![]() |
ToString | (Se hereda de Object.) |
![]() |
Update | This method updates the old package XML with the new package XML if CanUpdate is set to true. (Se hereda de ForEachEnumerator.) |
![]() |
Validate | Allows the container to determine if it contains invalid settings that will prevent it from executing successfully. (Se hereda de ForEachEnumerator.) |
Arriba
Comentarios
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.
Seguridad para subprocesos
Cualquier miembro público static (Shared en Visual Basic) de este tipo es seguro para subprocesos. No se garantiza que los miembros de instancia sean seguros para subprocesos.
Vea también
Referencia
Espacio de nombres Microsoft.SqlServer.Dts.Runtime.Enumerators.FromVar