Classe LogProviderInfo
Provides information about the log providers found on the computer. This class cannot be inherited.
Spazio dei nomi: Microsoft.SqlServer.Dts.Runtime
Assembly: Microsoft.SqlServer.ManagedDTS (in Microsoft.SqlServer.ManagedDTS.dll)
Sintassi
'Dichiarazione
Public NotInheritable Class LogProviderInfo _
Inherits DtsObject _
Implements IDTSName
'Utilizzo
Dim instance As LogProviderInfo
public sealed class LogProviderInfo : DtsObject,
IDTSName
public ref class LogProviderInfo sealed : public DtsObject,
IDTSName
[<SealedAttribute>]
type LogProviderInfo =
class
inherit DtsObject
interface IDTSName
end
public final class LogProviderInfo extends DtsObject implements IDTSName
Esempi
The following code example retrieves and iterates through all the properties of each log provider in the log provider collection.
using System;
using System.Collections.Generic;
using System.Text;
using Microsoft.SqlServer.Dts.Runtime;
namespace LogProvInfoProperties
{
class Program
{
static void Main(string[] args)
{
Application app = new Application();
LogProviderInfos infos = app.LogProviderInfos;
foreach(LogProviderInfo info in infos)
{
Console.WriteLine("CreationName {0}", info.CreationName);
Console.WriteLine("Description {0}", info.Description);
Console.WriteLine("FileName: {0}", info.FileName);
//Console.WriteLine("FileNameVersionString: {0}", info.FileNameVersionString);
Console.WriteLine("IconFile: {0}", info.IconFile);
Console.WriteLine("IconResource: {0}", info.IconResource);
Console.WriteLine("ID: {0}", info.ID);
Console.WriteLine("LogProviderContact {0}", info.LogProviderContact);
Console.WriteLine("LogProviderType {0}", info.LogProviderType);
Console.WriteLine("Name: {0}", info.Name);
Console.WriteLine("UITypeName {0}", info.UITypeName);
Console.WriteLine("__________________________");
}
}
}
}
Imports System
Imports System.Collections.Generic
Imports System.Text
Imports Microsoft.SqlServer.Dts.Runtime
Namespace LogProvInfoProperties
Class Program
Shared Sub Main(ByVal args() As String)
Dim app As Application = New Application()
Dim infos As LogProviderInfos = app.LogProviderInfos
Dim info As LogProviderInfo
For Each info In infos
Console.WriteLine("CreationName {0}", info.CreationName)
Console.WriteLine("Description {0}", info.Description)
Console.WriteLine("FileName: {0}", info.FileName)
'Console.WriteLine("FileNameVersionString: {0}", info.FileNameVersionString)
Console.WriteLine("IconFile: {0}", info.IconFile)
Console.WriteLine("IconResource: {0}", info.IconResource)
Console.WriteLine("ID: {0}", info.ID)
Console.WriteLine("LogProviderContact {0}", info.LogProviderContact)
Console.WriteLine("LogProviderType {0}", info.LogProviderType)
Console.WriteLine("Name: {0}", info.Name)
Console.WriteLine("UITypeName {0}", info.UITypeName)
Console.WriteLine("__________________________")
Next
End Sub
End Class
End Namespace
Sample Output:
CreationName DTS.LogProviderTextFile.2
Description Writes log entries for events to a CSV file
FileName: C:\Program Files\Microsoft SQL Server\100\DTS\Binn\DTSLog.dll
IconFile: C:\Program Files\Microsoft SQL Server\100\DTS\Binn\DTSLog.dll
IconResource: 0
ID: {59B2C6A5-663F-4C20-8863-C83F9B72E2EB}
LogProviderContact
LogProviderType DTS10
Name: SSIS log provider for Text files
UITypeName Microsoft.DataTransformationServices.Design.FileConnectionsLogProviderUI, Microsoft.DataTransformationServices.Design, Version=10.0.000.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91
__________________________
CreationName DTS.LogProviderSQLProfiler.2
Description Generates SQL traces that may be captured in SQL Server Profiler
FileName: C:\Program Files\Microsoft SQL Server\100\DTS\Binn\DTSLog.dll
IconFile: C:\Program Files\Microsoft SQL Server\100\DTS\Binn\DTSLog.dll
IconResource: 0
ID: {5C0B8D21-E9AA-462E-BA34-30FF5F7A42A1}
LogProviderContact
LogProviderType DTS10
Name: SSIS log provider for SQL Server Profiler
UITypeName Microsoft.DataTransformationServices.Design.FileConnectionsLogProviderUI, Microsoft.DataTransformationServices.Design, Version=10.0.000.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91
__________________________
CreationName DTS.LogProviderSQLServer.2
Description Writes log entries for events to a SQL Server database
FileName: C:\Program Files\Microsoft SQL Server\100\DTS\Binn\DTSLog.dll
IconFile: C:\Program Files\Microsoft SQL Server\100\DTS\Binn\DTSLog.dll
IconResource: 0
ID: {6AA833A1-E4B2-4431-831B-DE695049DC61}
LogProviderContact
LogProviderType DTS10
Name: SSIS log provider for SQL Server
UITypeName Microsoft.DataTransformationServices.Design.OleDbConnectionsLogProviderUI, Microsoft.DataTransformationServices.Design, Version=10.0.000.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91
__________________________
Gerarchia di ereditarietà
System. . :: . .Object
Microsoft.SqlServer.Dts.Runtime. . :: . .DtsObject
Microsoft.SqlServer.Dts.Runtime..::..LogProviderInfo
Thread Safety
Tutti i membri pubblici static (Shared in Visual Basic) di questo tipo sono thread safe. I membri di istanza non hanno garanzia di essere thread safe.