Application.ForEachEnumeratorInfos Property

 

Returns a ForEachEnumeratorInfos collection that contains ForEachEnumeratorInfo objects. This property is read-only.

Namespace:   Microsoft.SqlServer.Dts.Runtime
Assembly:  Microsoft.SqlServer.ManagedDTS (in Microsoft.SqlServer.ManagedDTS.dll)

Public ReadOnly Property ForEachEnumeratorInfos As ForEachEnumeratorInfos

Property Value

Type: Microsoft.SqlServer.Dts.Runtime.ForEachEnumeratorInfos

A ForEachEnumeratorInfos collection that contains all the ForEachEnumeratorInfo objects in the application.

The following code example shows how to enumerate the different ForEach enumerators provided by Integration Services.

class ApplicationTests
    Sub Main(ByVal args() As String)
        Dim app As Application =  New Application() 
        Dim fee As ForEachEnumeratorInfos =  app.ForEachEnumeratorInfos 
        For Each x As ForEachEnumeratorInfo In fee
            Console.WriteLine(x.ID)
        Next
    End Sub
End Class

Sample Output:

{62C3D0D9-C6A3-4A08-84F3-6028B2452F41}

Microsoft.SqlServer.Dts.Runtime.Enumerators.ADO.ForEachADOEnumerator,

Microsoft.SqlServer.ForEachADOEnumerator, Version=10.0.0.0, Culture=neutral,

PublicKeyToken=89845dcd8080cc91

Microsoft.SqlServer.Dts.Runtime.Enumerators.FromVar.ForEachFromVarEnumerator,

Microsoft.SqlServer.ForEachFromVarEnumerator, Version=10.0.0.0, Culture=neutral,

PublicKeyToken=89845dcd8080cc91

Microsoft.SqlServer.Dts.Runtime.Enumerators.NodeList.ForEachNodeListEnumerator,

Microsoft.SqlServer.ForEachNodeListEnumerator, Version=10.0.0.0, Culture=neutral,

PublicKeyToken=89845dcd8080cc91

Microsoft.SqlServer.Dts.Runtime.Enumerators.SMO.ForEachSMOEnumerator,

Microsoft.SqlServer.ForEachSMOEnumerator, Version=10.0.0.0, Culture=neutral,

PublicKeyToken=89845dcd8080cc91

Return to top
Show: