Sdílet prostřednictvím

  • Článek

ForEachFromVarEnumerator.VariableName Property

Gets or sets the name of the variable to enumerate.

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

Syntax

'Declaration
Public Property VariableName As String
    Get
    Set
'Usage
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)

Property Value

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

Implements

IDTSForEachFromVarEnumerator.VariableName

Remarks

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.