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)

public string VariableName { get; set; }

Property Value

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



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.

Community Additions