LogEntryInfos.GetEnumerator Methode

Definition

Namespace:

Microsoft.SqlServer.Dts.Runtime

Assembly:

Microsoft.SqlServer.ManagedDTS.dll

Returns hat es geschafft LogEntryInfoEnumerator , über die LogEntryInfos Sammlung zu iterieren.

public:
 Microsoft::SqlServer::Dts::Runtime::LogEntryInfoEnumerator ^ GetEnumerator();

public Microsoft.SqlServer.Dts.Runtime.LogEntryInfoEnumerator GetEnumerator();

override this.GetEnumerator : unit -> Microsoft.SqlServer.Dts.Runtime.LogEntryInfoEnumerator

Public Function GetEnumerator () As LogEntryInfoEnumerator

Gibt zurück

LogEntryInfoEnumerator

LogEntryInfoEnumerator A, um die LogEntryInfos Sammlung zu iterieren.

Beispiele

Das folgende Codebeispiel erstellt eine LogEntryInfoEnumerator mit der Methode GetEnumerator und iteriert dann über die Sammlung.

using System;  
using System.Collections.Generic;  
using System.Text;  
using Microsoft.SqlServer.Dts.Runtime;  

namespace LogEntryInfosTest  
{  
    class Program  
    {  
        static void Main(string[] args)  
        {  
            // The package is one of the SSIS Samples.  
            string mySample = @"C:\Program Files\Microsoft SQL Server\100\Samples\Integration Services\Package Samples\CalculatedColumns Sample\CalculatedColumns\CalculatedColumns.dtsx";  

            // Create the Application, and load the sample.  
            Application app = new Application();  
            Package pkg = app.LoadPackage(mySample, null);  

            //Create the Enumerator.  
            LogEntryInfos leInfos = pkg.LogEntryInfos;  
            LogEntryInfoEnumerator myEnumerator = leInfos.GetEnumerator();  
            Console.WriteLine("The collection contains the following values:");  
            int i = 0;  
            while ((myEnumerator.MoveNext()) && (myEnumerator.Current != null))  
                Console.WriteLine("[{0}] {1}", i++, myEnumerator.Current);  

            Console.WriteLine();  
        }  
    }  
}  

Imports System  
Imports System.Collections.Generic  
Imports System.Text  
Imports Microsoft.SqlServer.Dts.Runtime  

Namespace LogEnTryInfosTest  
    Class Program  
        Shared  Sub Main(ByVal args() As String)  
            ' The package is one of the SSIS Samples.  
            Dim mySample As String =  "C:\Program Files\Microsoft SQL Server\100\Samples\Integration Services\Package Samples\CalculatedColumns Sample\CalculatedColumns\CalculatedColumns.dtsx"   

            ' Create the Application, and load the sample.  
            Dim app As Application =  New Application()   
            Dim pkg As Package =  app.LoadPackage(mySample,Nothing)   

            'Create the Enumerator.  
            Dim leInfos As LogEnTryInfos =  pkg.LogEnTryInfos   
            Dim myEnumerator As LogEnTryInfoEnumerator =  leInfos.GetEnumerator()   
            Console.WriteLine("The collection contains the following values:")  
            Dim i As Integer =  0   
            While (myEnumerator.MoveNext()) &&(myEnumerator.Current <> Nothing)  
            Console.WriteLine("[{0}] {1}",i = Console.WriteLine("[{0}] {1}",i + 1  
            End While  

            Console.WriteLine()  
        End Sub  
    End Class  
End Namespace  

Beispielausgabe:

Die Sammlung enthält folgende Werte:

[0] Microsoft. SqlServer.Dts.Runtime.LogEntryInfo