LogProviderInfo-Klasse
Provides information about the log providers found on the computer. This class cannot be inherited.
Vererbungshierarchie
System. . :: . .Object
Microsoft.SqlServer.Dts.Runtime. . :: . .DtsObject
Microsoft.SqlServer.Dts.Runtime..::..LogProviderInfo
Namespace: Microsoft.SqlServer.Dts.Runtime
Assembly: Microsoft.SqlServer.ManagedDTS (in Microsoft.SqlServer.ManagedDTS.dll)
Syntax
'Declaration
Public NotInheritable Class LogProviderInfo _
Inherits DtsObject _
Implements IDTSName
'Usage
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
Der LogProviderInfo-Typ macht folgende Elemente verfügbar.
Eigenschaften
Name | Beschreibung | |
---|---|---|
CreationName | Returns the string used by the runtime engine to create an instance of the LogProvider object and to add the object to the LogProviders collection. This property is read-only. | |
Description | Returns the description for the log provider. This property is read-only. | |
FileName | Returns the name of the log provider file. This property is read-only. | |
FileNameVersionString | Returns the file name version string of the log provider. This property is read-only. | |
IconFile | Returns the name of the file that contains the icon. This property is read-only. | |
IconResource | Returns the resource identifier of the icon. This property is read-only. | |
ID | Returns the GUID that uniquely identifies this log provider. This property is read-only. | |
LogProviderContact | Returns the contact information for the log provider. This property is read-only. | |
LogProviderType | Returns the type of the log provider. This property is read-only. | |
Name | Gets or sets a name for the log provider. | |
UITypeName | Returns the UIType name for the log provider user interface. |
Zum Anfang
Methoden
Name | Beschreibung | |
---|---|---|
Equals | Determines whether two object instances are equal. (Geerbt von DtsObject.) | |
Finalize | (Geerbt von Object.) | |
GetHashCode | Returns the hash code for this instance. (Geerbt von DtsObject.) | |
GetType | (Geerbt von Object.) | |
MemberwiseClone | (Geerbt von Object.) | |
ToString | (Geerbt von Object.) |
Zum Anfang
Beispiele
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
Threadsicherheit
Alle öffentlichen static (Shared in Visual Basic)-Elemente dieses Typs sind Threadsicher. Für Instanzelemente wird die Threadsicherheit nicht gewährleistet.