Application.ForEachEnumeratorInfos Property

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

class ApplicationTests
    {
        static void Main(string[] args)
        {
            Application app = new Application();
            ForEachEnumeratorInfos fee = app.ForEachEnumeratorInfos;
            foreach(ForEachEnumeratorInfo x in fee)
                Console.WriteLine(x.ID);
        }
    }

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

Reference