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)

Syntax

'Declaration
Public ReadOnly Property ForEachEnumeratorInfos As ForEachEnumeratorInfos 
    Get
'Usage
Dim instance As Application 
Dim value As ForEachEnumeratorInfos 

value = instance.ForEachEnumeratorInfos

public ForEachEnumeratorInfos ForEachEnumeratorInfos { get; }

public:
property ForEachEnumeratorInfos^ ForEachEnumeratorInfos {
    ForEachEnumeratorInfos^ get ();
}

member ForEachEnumeratorInfos : ForEachEnumeratorInfos

function get ForEachEnumeratorInfos () : ForEachEnumeratorInfos

Property Value

Type: Microsoft.SqlServer.Dts.Runtime.ForEachEnumeratorInfos
A ForEachEnumeratorInfos collection that contains all the ForEachEnumeratorInfo objects in the application.

Examples

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

See Also

Reference

Application Class

Microsoft.SqlServer.Dts.Runtime Namespace