• Artigo

Propriedade do RDL VariableName

Gets or sets the name of the variable to enumerate.

Namespace:  Microsoft.SqlServer.Dts.Runtime.Enumerators.FromVar
Assembly:  Microsoft.SqlServer.ForEachFromVarEnumerator (em Microsoft.SqlServer.ForEachFromVarEnumerator.dll)

Sintaxe

'Declaração
Public Property VariableName As String
    Get
    Set
'Uso
Dim instance As ForEachFromVarEnumerator
Dim value As String

value = instance.VariableName

instance.VariableName = value

public string VariableName { get; set; }

public:
virtual property String^ VariableName {
    String^ get () sealed;
    void set (String^ value) sealed;
}

abstract VariableName : string with get, set
override VariableName : string with get, set

final function get VariableName () : String
final function set VariableName (value : String)

Valor da propriedade

Tipo: System. . :: . .String
A String that contains the name of the variable to enumerate.

Implementa

IDTSForEachFromVarEnumerator. . :: . .VariableName

Comentários

The variable that you use with the Foreach from Variable Enumerator must be of type Object. The object that you place in the variable must implement one of the following interfaces:

  • System.Collections.IEnumerable

  • System.Runtime.InteropServices.ComTypes.IEnumVARIANT

  • System.ComponentModel IListSource

  • Microsoft.SqlServer.Dts.Runtime.Wrapper.ForEachEnumeratorHost

An Array or ArrayList is commonly used. If you use an ArrayList, you need to reference the System.Collections namespace.