Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

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 Property VariableName As String 
Dim instance As ForEachFromVarEnumerator 
Dim value As String 

value = instance.VariableName

instance.VariableName = value

Property Value

Type: 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

© 2015 Microsoft