LogProviderInfo Class
Provides information about the log providers found on the computer. This class cannot be inherited.
Inheritance Hierarchy
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
The LogProviderInfo type exposes the following members.
Properties
| Name | Description | |
|---|---|---|
.gif "Public property") |
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. |
Top
Methods
| Name | Description | |
|---|---|---|
.gif "Public method") |
Equals | Determines whether two object instances are equal. (Inherited from DtsObject.) |
|
GetHashCode | Returns the hash code for this instance. (Inherited from DtsObject.) |
|
GetType | (Inherited from Object.) |
|
ToString | (Inherited from Object.) |
Top
Remarks
This class inherits from DtsObject and IDTSName.
Examples
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.1
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.1
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.1
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
__________________________
Thread Safety
Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.