Export (0) Print
Expand All

LogProviderInfo Class

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

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)

public sealed class LogProviderInfo : DtsObject, 
	IDTSName

The LogProviderInfo type exposes the following members.

  NameDescription
Public propertyCreationNameReturns 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.
Public propertyDescriptionReturns the description for the log provider. This property is read-only.
Public propertyFileNameReturns the name of the log provider file. This property is read-only.
Public propertyFileNameVersionStringReturns the file name version string of the log provider. This property is read-only.
Public propertyIconFileReturns the name of the file that contains the icon. This property is read-only.
Public propertyIconResourceReturns the resource identifier of the icon. This property is read-only.
Public propertyIDReturns the GUID that uniquely identifies this log provider. This property is read-only.
Public propertyLogProviderContactReturns the contact information for the log provider. This property is read-only.
Public propertyLogProviderTypeReturns the type of the log provider. This property is read-only.
Public propertyNameGets or sets a name for the log provider.
Public propertyUITypeNameReturns the UIType name for the log provider user interface.
Top

  NameDescription
Public methodEqualsDetermines whether two object instances are equal. (Inherited from DtsObject.)
Public methodGetHashCodeReturns the hash code for this instance. (Inherited from DtsObject.)
Public methodGetType (Inherited from Object.)
Public methodToString (Inherited from Object.)
Top

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.

Community Additions

ADD
Show:
© 2014 Microsoft