This topic has not yet been rated - Rate this topic

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)

Syntax

C++

JScript

Copy

public enum DTSLoggingMode

Members

	Member name	Description
	UseParentSetting	Logging value is taken from the logging mode setting of the parent container.
	Enabled	Logging is enabled.
	Disabled	Logging is disabled.

Remarks

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.

Examples

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

Copy

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

Reference

Microsoft.SqlServer.Dts.Runtime Namespace

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)