共用方式為

Application.ForEachEnumeratorInfos Property

  • Reference

Definition

Namespace:
Microsoft.SqlServer.Dts.Runtime
Assembly:
Microsoft.SqlServer.ManagedDTS.dll

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

public:
 property Microsoft::SqlServer::Dts::Runtime::ForEachEnumeratorInfos ^ ForEachEnumeratorInfos { Microsoft::SqlServer::Dts::Runtime::ForEachEnumeratorInfos ^ get(); };
public Microsoft.SqlServer.Dts.Runtime.ForEachEnumeratorInfos ForEachEnumeratorInfos { get; }
member this.ForEachEnumeratorInfos : Microsoft.SqlServer.Dts.Runtime.ForEachEnumeratorInfos
Public ReadOnly Property ForEachEnumeratorInfos As ForEachEnumeratorInfos

Property Value

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

Applies to