Export (0) Print
Expand All

LogProviders.Add Method

Adds the specified log provider to the end of the collection.

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

public LogProvider Add(
	string logProviderClsidOrProgId
)

Parameters

logProviderClsidOrProgId
Type: String
The class ID or ProgID of the log provider to add to the collection.

Return Value

Type: Microsoft.SqlServer.Dts.Runtime.LogProvider
The LogProvider object added to the collection.

When you add a log provider to the collection, you can add it using its ClassID (GUID) or ProgID. The following list shows the available loggers and their IDs.

Text file:

  • ProgID: DTS.LogProviderTextFile.1

  • ClassID: {59B2C6A5-663F-4C20-8863-C83F9B72E2EB}

SQL Server Profiler:

  • ProgID: DTS.LogProviderSQLProfiler.1

  • ClassID: {5C0B8D21-E9AA-462E-BA34-30FF5F7A42A1}

SQL Server:

  • ProgID: DTS.LogProviderSQLServer.1

  • ClassID: {6AA833A1-E4B2-4431-831B-DE695049DC61}

Windows Event Log:

  • ProgID: DTS.LogProviderEventLog.1

  • ClassID: {97634F75-1DC7-4F1F-8A4C-DAF0E13AAA22}

XML File:

  • ProgID: DTS.LogProviderXMLFile.1

  • ClassID: {AFED6884-619C-484F-9A09-F42D56E1A7EA}

The following code sample adds the SQL Server log provider to the collection using its ProgID. In the console output from the foreach (C#) loop, notice the position in the collection and the name assigned to the newly-added log provider.

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.1");

            // 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);
            }
        }
    }
}

Sample Output:

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

Community Additions

ADD
Show:
© 2014 Microsoft