Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

DTSLogEntryFrequency Enumeration

Provides information to assist in log planning. You pick the hint that most closely corresponds to the frequency that you expect to generate a particular log entry in your task. This enumeration property then assists users of the package when they want to set up filtering of log entries. The user can view the property, and know in advance if there will be an overwhelming number of entries of a particular type, and plan accordingly.

Namespace:  Microsoft.SqlServer.Dts.Runtime
Assembly:  Microsoft.SqlServer.ManagedDTS (in Microsoft.SqlServer.ManagedDTS.dll)
public enum DTSLogEntryFrequency
Member nameDescription
ConsistentThe entry is logged a consistent number of times, not proportional to the workload. For example, a log that is created at the beginning and in the end of a task.
OccasionalThe entry is logged sometimes, usually in exceptional cases.
ProportionalThe entry is logged a number of times proportional to the workload.

The following code example iterates over the LogEntryInfos collection, and then prints the properties of each LogEntryInfo found, including FrequencyHint, which returns a value from this enumeration. The code example does show how to set the FrequencyHint because the property is read-only.

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\100\Samples\Integration Services\Package Samples\CalculatedColumns Sample\CalculatedColumns\CalculatedColumns.dtsx";

            Application app = new Application();
            Package pkg = app.LoadPackage(mySample, null);
            LogEntryInfos logInfos = pkg.LogEntryInfos;

            Console.WriteLine("Number of log entries:  {0}", logInfos.Count.ToString());
            foreach (LogEntryInfo logInfo in logInfos)
            {
                Console.WriteLine("CreationName:   {0}", logInfo.CreationName);
                Console.WriteLine("Description:    {0}", logInfo.Description);
                Console.WriteLine("FrequencyHint:  {0}", logInfo.FrequencyHint);
                Console.WriteLine("ID:             {0}", logInfo.ID);
                Console.WriteLine("Name:           {0}", logInfo.Name);
            }
        }
    }
}

Sample Output:

Number of log entries: 1

CreationName:

Description: Logs package diagnostics information, e.g. maximum concurrent executables

FrequencyHint: Consistent

ID: {65F44252-EB0C-4CCB-ADE4-BA4AB86B4CF9}

Name: Diagnostic

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.