LogProviders.GetEnumerator Metodo
Definizione
Importante
Alcune informazioni sono relative alla release non definitiva del prodotto, che potrebbe subire modifiche significative prima della release definitiva. Microsoft non riconosce alcuna garanzia, espressa o implicita, in merito alle informazioni qui fornite.
Restituisce un oggetto LogProviderEnumerator da utilizzare per scorrere la raccolta LogProviders.
public:
Microsoft::SqlServer::Dts::Runtime::LogProviderEnumerator ^ GetEnumerator();
public Microsoft.SqlServer.Dts.Runtime.LogProviderEnumerator GetEnumerator ();
override this.GetEnumerator : unit -> Microsoft.SqlServer.Dts.Runtime.LogProviderEnumerator
Public Function GetEnumerator () As LogProviderEnumerator
Restituisce
Oggetto LogProviderEnumerator da utilizzare per scorrere la raccolta.
Esempio
Nell'esempio di codice seguente viene creato un oggetto LogProviderEnumerator utilizzando il GetEnumerator metodo, quindi viene eseguita l'iterazione della raccolta.
using System;
using System.Collections.Generic;
using System.Text;
using Microsoft.SqlServer.Dts.Runtime;
namespace LogProviderInfos_testing
{
class Program
{
static void Main(string[] args)
{
// The package is one of the SSIS Samples. The package
// was modified in the designer to log to the SSIS log
// provider for Text files before being loaded
// for this code example.
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);
// Get the LogProviders collection from the package.
LogProviders logProvs = pkg.LogProviders;
//Create the Enumerator.
LogProviderEnumerator myEnumerator = logProvs.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.Name);
}
}
}
Imports System
Imports System.Collections.Generic
Imports System.Text
Imports Microsoft.SqlServer.Dts.Runtime
Namespace LogProviderInfos_testing
Class Program
Shared Sub Main(ByVal args() As String)
' The package is one of the SSIS Samples. The package
' was modified in the designer to log to the SSIS log
' provider for Text files before being loaded
' for this code example.
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)
' Get the LogProviders collection from the package.
Dim logProvs As LogProviders = pkg.LogProviders
'Create the Enumerator.
Dim myEnumerator As LogProviderEnumerator = logProvs.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
End Sub
End Class
End Namespace
Esempio di output
La raccolta contiene i valori seguenti:
[0] provider di log SSIS per file di testo