Makale
07/26/2011

LogProviders.Add Yöntemi

Belirtilen günlük sağlayıcı sonuna ekler koleksiyon.

Ad Alanı: Microsoft.SqlServer.Dts.Runtime
Derleme: Microsoft.SqlServer.ManagedDTS (Microsoft.SqlServer.ManagedDTS içinde.dll)

Sözdizimi

'Bildirim
Public Function Add ( _
    logProviderClsidOrProgId As String _
) As LogProvider
'Kullanım
Dim instance As LogProviders
Dim logProviderClsidOrProgId As String
Dim returnValue As LogProvider

returnValue = instance.Add(logProviderClsidOrProgId)

public LogProvider Add(
    string logProviderClsidOrProgId
)

public:
LogProvider^ Add(
    String^ logProviderClsidOrProgId
)

member Add : 
        logProviderClsidOrProgId:string -> LogProvider

public function Add(
    logProviderClsidOrProgId : String
) : LogProvider

Parametreler

logProviderClsidOrProgId
Tür: System.String
Sınıf kimliği veya eklemek için günlük sağlayıcı ProgID koleksiyon.

Dönüş Değeri

Tür: Microsoft.SqlServer.Dts.Runtime.LogProvider
LogProvider Eklenen nesne koleksiyon.

Açıklamalar

Koleksiyon için günlük sağlayıcı eklediğinizde, onun (GUID) ClassID veya ProgID kullanarak ekleyebilirsiniz.Aşağıdaki listede kullanılabilir loggers ve kendi kimliklerini gösterir.

Metin dosyası:

ProgID: DTS.LogProviderTextFile.2
ClassID: {59B2C6A5-663F-4 C 20-8863-C83F9B72E2EB}

sql Server Profiler'I:

ProgID: DTS.LogProviderSQLProfiler.2
ClassID: 5C0B8D21-E9AA-462E-BA34-30FF5F7A42A1

sql Server:

ProgID: DTS.LogProviderSQLServer.2
ClassID: 6AA833A1-E4B2-4431-831B-DE695049DC61

Windows olay günlüğü:

ProgID: DTS.LogProviderEventLog.2
ClassID: 97634F75-1DC7-4F1F-8A4C-DAF0E13AAA22

xml dosyası:

ProgID: DTS.LogProviderXMLFile.2
ClassID: DEĞERİ KULLANILIR: {AFED6884-619 C-484F-9A09-F42D56E1A7EA}

Örnekler

Aşağıdaki kod örneği ekler SQL Server kullanarak koleksiyon için günlük sağlayıcıkendi ProgID.Konsol çıktısını, foreach (C#) döngü, konumu fark koleksiyon ve yeni eklenen günlük sağlayıcı için atanan ad.

using System;
using System.Collections.Generic;
using System.Text;
using Microsoft.SqlServer.Dts.Runtime;

namespace LogProviders_Tests
{
    class Program
    {
        static void Main(string[] args)
        {
            // The package is one of the SSIS Samples.
            string mySample = @"C:\Program Files\Microsoft SQL Server\100\Samples\Integration Services\Package Samples\ExecuteProcess Sample\ExecuteProcess\UsingExecuteProcess.dtsx";

            // Create the Application, and load the sample.
            Application app = new Application();
            Package pkg = app.LoadPackage(mySample, null);
            LogProviders logProvs = pkg.LogProviders;

            // Count the number of providers in the package.
            int countProvs = logProvs.Count;
            Console.WriteLine("Initial number of log providers: {0}", countProvs);

            // Since the package that was loaded only contained the
            // SSIS Log provider for Text files, let's add the SQL
            // Server log provider.
            LogProvider logProv = pkg.LogProviders.Add("DTS.LogProviderSQLServer.2");

            // Count how many log providers are in the collection now.
            countProvs = logProvs.Count;
            Console.WriteLine("The number of log providers now: {0}", countProvs);
            Console.WriteLine("----------------------------");

            foreach (LogProvider lp in logProvs)
            {
                Console.WriteLine("Log Provider Name: {0}", lp.Name);
            }
        }
    }
}

Imports System
Imports System.Collections.Generic
Imports System.Text
Imports Microsoft.SqlServer.Dts.Runtime
 
Namespace LogProviders_Tests
    Class Program
        Shared  Sub Main(ByVal args() As String)
            ' The package is one of the SSIS Samples.
            Dim mySample As String =  "C:\Program Files\Microsoft SQL Server\100\Samples\Integration Services\Package Samples\ExecuteProcess Sample\ExecuteProcess\UsingExecuteProcess.dtsx" 
 
            ' Create the Application, and load the sample.
            Dim app As Application =  New Application() 
            Dim pkg As Package =  app.LoadPackage(mySample,Nothing) 
            Dim logProvs As LogProviders =  pkg.LogProviders 
 
            ' Count the number of providers in the package.
            Dim countProvs As Integer =  logProvs.Count 
            Console.WriteLine("Initial number of log providers: {0}", countProvs)
 
            ' Since the package that was loaded only contained the
            ' SSIS Log provider for Text files, let's add the SQL
            ' Server log provider.
            Dim logProv As LogProvider =  pkg.LogProviders.Add("DTS.LogProviderSQLServer.2") 
 
            ' Count how many log providers are in the collection now.
            countProvs = logProvs.Count
            Console.WriteLine("The number of log providers now: {0}", countProvs)
            Console.WriteLine("----------------------------")
 
            Dim lp As LogProvider
            For Each lp In logProvs
                Console.WriteLine("Log Provider Name: {0}", lp.Name)
            Next
        End Sub
    End Class
End Namespace

Örnek Çıktı:

Initial number of log providers: 1

The number of log providers now: 2

----------------------------

Log Provider Name: {FCA3ACD4-C080-4B67-A1AA-45118D3DA672}

Log Provider Name: SSIS log provider for Text files

Ayrıca bkz.

Başvuru

LogProviders Sınıf

Microsoft.SqlServer.Dts.Runtime Ad Alanı

Aracılığıyla paylaş