Export (0) Print
Expand All

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 ForEachEnumeratorInfos ForEachEnumeratorInfos { get; }
/** @property */
public ForEachEnumeratorInfos get_ForEachEnumeratorInfos ()

public function get ForEachEnumeratorInfos () : ForEachEnumeratorInfos

Property Value

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
    {
        static void Main(string[] args)
        {
            Application app = new Application();
            ForEachEnumeratorInfos fee = app.ForEachEnumeratorInfos;
            foreach(ForEachEnumeratorInfo x in fee)
                Console.WriteLine(x.ID);
        }
    }

Sample Output:

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

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

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

PublicKeyToken=89845dcd8080cc91

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

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

PublicKeyToken=89845dcd8080cc91

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

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

PublicKeyToken=89845dcd8080cc91

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

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

PublicKeyToken=89845dcd8080cc91

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms

Community Additions

ADD
Show:
© 2014 Microsoft