Remarque
L’accès à cette page nécessite une autorisation. Vous pouvez essayer de vous connecter ou de modifier des répertoires.
L’accès à cette page nécessite une autorisation. Vous pouvez essayer de modifier des répertoires.
Returns a managed LogEntryInfoEnumerator to iterate over the LogEntryInfos collection.
Espace de noms: Microsoft.SqlServer.Dts.Runtime
Assembly: Microsoft.SqlServer.ManagedDTS (in microsoft.sqlserver.manageddts.dll)
Syntaxe
'Déclaration
Public Function GetEnumerator As LogEntryInfoEnumerator
public LogEntryInfoEnumerator GetEnumerator ()
public:
LogEntryInfoEnumerator^ GetEnumerator ()
public LogEntryInfoEnumerator GetEnumerator ()
public function GetEnumerator () : LogEntryInfoEnumerator
Valeur de retour
A LogEntryInfoEnumerator.
Exemple
The following code sample creates a LogEntryInfoEnumerator using the GetEnumerator method, and then iterates over the collection.
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\90\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\90\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
Sample Output:
The collection contains the following values:
[0] Microsoft.SqlServer.Dts.Runtime.LogEntryInfo
Sécurité des threads
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.
Plateformes
Plateformes de développement
Pour obtenir la liste des plateformes prises en charge, consultez Configuration matérielle et logicielle requise pour l'installation de SQL Server 2005.
Plateformes cibles
Pour obtenir la liste des plateformes prises en charge, consultez Configuration matérielle et logicielle requise pour l'installation de SQL Server 2005.
Voir aussi
Référence
LogEntryInfos Class
LogEntryInfos Members
Microsoft.SqlServer.Dts.Runtime Namespace