LogProviderInfo.LogProviderType Propiedad

Definición

Espacio de nombres:

Microsoft.SqlServer.Dts.Runtime

Ensamblado:

Microsoft.SqlServer.ManagedDTS.dll

Devuelve el tipo del proveedor de registro. Esta propiedad es de sólo lectura.

public:
 property System::String ^ LogProviderType { System::String ^ get(); };

public string LogProviderType { get; }

member this.LogProviderType : string

Public ReadOnly Property LogProviderType As String

Valor de propiedad

String

Cadena que contiene información sobre el tipo de proveedor de registro que es.

Ejemplos

En el ejemplo de código siguiente se recuperan e iteran todas las propiedades de cada proveedor de registro de la colección de proveedores de registros y, a continuación, se imprimen los valores, incluido el valor de LogProviderType.

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  

Salida del ejemplo:

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

__________________________