Export (0) Print
Expand All

DtsContainer.LogEntryInfos Property

Returns a LogEntryInfos object. This property is read-only.

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

public LogEntryInfos LogEntryInfos { get; }
/** @property */
public LogEntryInfos get_LogEntryInfos ()

public function get LogEntryInfos () : LogEntryInfos

Property Value

A LogEntryInfos object.

For more information, see Integration Services Log Providers.


The following code example shows the Package using the Package.LogEntryInfos collection. The Package class inherits the use of the LogEntryInfos collection from DtsContainer.

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

namespace LogEntryInfosTest
{
    class Program
    {
        static void Main(string[] args)
        {
            // The package is one of the SSIS Samples.
            string mySample = @"C:\Program Files\Microsoft SQL Server\90\Samples\Integration Services\Package Samples\CalculatedColumns Sample\CalculatedColumns\CalculatedColumns.dtsx";
    
            // Create the Application, and load the sample.
            Application app = new Application();
            Package pkg= app.LoadPackage(mySample, null);

            // Get the LogEntryInfos from the package.
            LogEntryInfos logInfos = pkg.LogEntryInfos;

            //Note how many log entries exist before adding one.
            String countLEI = logInfos.Count.ToString();
            Console.WriteLine("Entries at beginning: {0}", countLEI);
 
            String newName = "My new log entry info";
            String newDesc = "My new Description";
            DTSLogEntryFrequency newFreq = DTSLogEntryFrequency.Consistent;
            logInfos.Add(newName, newDesc, newFreq);

            //Note how many log entries exist after adding one.
            countLEI = logInfos.Count.ToString();
            Console.WriteLine("Entries after adding one: {0}", countLEI);

            //Now remove the entry just added.
            logInfos.Remove("My new log entry info");
            countLEI = logInfos.Count.ToString();
            Console.WriteLine("Entries after Remove: {0}", countLEI);
        }
    }
}

Sample Output:

Entries at beginning: 1

Entries after adding one: 2

Entries after Remove: 1

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms

Community Additions

ADD
Show:
© 2015 Microsoft