LogEntryInfos.GetEnumerator Método

Definición

Espacio de nombres:

Microsoft.SqlServer.Dts.Runtime

Ensamblado:

Microsoft.SqlServer.ManagedDTS.dll

Devuelve un enumerador LogEntryInfoEnumerator administrado para iterar por la colección LogEntryInfos.

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

Devoluciones

LogEntryInfoEnumerator

Objeto LogEntryInfoEnumerator para iterar por la colección LogEntryInfos.

Ejemplos

El ejemplo de código siguiente crea un LogEntryInfoEnumerator mediante el GetEnumerator método y, a continuación, recorre en iteración la colección.

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  

Salida del ejemplo:

La colección contiene los siguientes valores:

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