LogProviderInfo Class
TOC
Collapse the table of content
Expand the table of content

LogProviderInfo Class

 

Provides information about the log providers found on the computer. This class cannot be inherited.

Namespace:   Microsoft.SqlServer.Dts.Runtime
Assembly:  Microsoft.SqlServer.ManagedDTS (in Microsoft.SqlServer.ManagedDTS.dll)

System.Object
  Microsoft.SqlServer.Dts.Runtime.DtsObject
    Microsoft.SqlServer.Dts.Runtime.LogProviderInfo

public sealed class LogProviderInfo : DtsObject, IDTSName

NameDescription
System_CAPS_pubpropertyCreationName

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.

System_CAPS_pubpropertyDescription

Returns the description for the log provider. This property is read-only.

System_CAPS_pubpropertyFileName

Returns the name of the log provider file. This property is read-only.

System_CAPS_pubpropertyFileNameVersionString

Returns the file name version string of the log provider. This property is read-only.

System_CAPS_pubpropertyIconFile

Returns the name of the file that contains the icon. This property is read-only.

System_CAPS_pubpropertyIconResource

Returns the resource identifier of the icon. This property is read-only.

System_CAPS_pubpropertyID

Returns the GUID that uniquely identifies this log provider. This property is read-only.

System_CAPS_pubpropertyLogProviderContact

Returns the contact information for the log provider. This property is read-only.

System_CAPS_pubpropertyLogProviderType

Returns the type of the log provider. This property is read-only.

System_CAPS_pubpropertyName

Gets or sets a name for the log provider.

System_CAPS_pubpropertyUITypeName

Returns the UIType name for the log provider user interface.

NameDescription
System_CAPS_pubmethodEquals(Object)

Determines whether two object instances are equal.(Inherited from DtsObject.)

System_CAPS_pubmethodGetHashCode()

Returns the hash code for this instance.(Inherited from DtsObject.)

System_CAPS_pubmethodGetType()

(Inherited from Object.)

System_CAPS_pubmethodToString()

(Inherited from Object.)

This class inherits from DtsObject and IDTSName.

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("__________________________");

          }
        }
    }
}

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

__________________________

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Return to top
Show:
© 2016 Microsoft