DTSLoggingMode Enumeration
Collapse the table of content
Expand the table of content

DTSLoggingMode Enumeration

Specifies the logging behavior of the container. The container can turn on logging, disable logging, or specify that the setting to use is the setting found on the parent container.

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

public enum DTSLoggingMode
public enum DTSLoggingMode
public enum DTSLoggingMode

Member nameDescription
DisabledLogging is disabled.
EnabledLogging is enabled.
UseParentSettingLogging value is taken from the logging mode setting of the parent container.

This enumeration is used by objects that have a LoggingMode property. The LoggingMode property is initially defined in the DtsContainer, and eventually inherited by containers such as the Package, Sequence, and other containers.

The following code example shows how to set the logging mode of a package by using this enumeration.

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

namespace Microsoft.SqlServer.SSIS.Samples
    class Program
        static void Main(string[] args)
            Package pkg = new Package();
            // The packages is assigned the following default value.
            Console.WriteLine("Default LoggingMode: {0}", pkg.LoggingMode);

            // Modify the default value.
            pkg.LoggingMode = DTSLoggingMode.Disabled;
            Console.WriteLine("New LoggingMode:     {0}", pkg.LoggingMode);

Sample output:

Default LoggingMode: UseParentSetting

New LoggingMode: Disabled

Development Platforms

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

Target Platforms

Community Additions

© 2015 Microsoft