LogProviderInfo.ID Properti

Definisi

Ruang nama:

Microsoft.SqlServer.Dts.Runtime

Rakitan:

Microsoft.SqlServer.ManagedDTS.dll

Mengembalikan GUID yang secara unik mengidentifikasi penyedia log ini. Properti ini bersifat hanya baca.

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

public string ID { get; }

member this.ID : string

Public ReadOnly Property ID As String

Nilai Properti

String

String yang berisi GUID unik.

Penerapan

ID

Contoh

Contoh kode berikut mengambil dan melakukan iterasi melalui semua properti setiap penyedia log dalam koleksi penyedia log, lalu mencetak nilai, termasuk nilai untuk ID.

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  

Contoh 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

__________________________