DTSLoggingMode Enum

Reference

Definition

Namespace:: Microsoft.SqlServer.Dts.Runtime

Assembly:: Microsoft.SqlServer.ManagedDTS.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

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.

public enum class DTSLoggingMode

public enum DTSLoggingMode

type DTSLoggingMode =

Public Enum DTSLoggingMode

Inheritance: Enum
DTSLoggingMode

Fields

Name	Value	Description
UseParentSetting	0	Logging value is taken from the logging mode setting of the parent container.
Enabled	1	Logging is enabled.
Disabled	2	Logging is disabled.

Examples

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

Imports System  
Imports System.Collections.Generic  
Imports System.Text  
Imports Microsoft.SqlServer.Dts.Runtime  

Namespace Microsoft.SqlServer.SSIS.Samples  
    Class Program  
        Shared  Sub Main(ByVal args() As String)  
            Dim pkg As Package =  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)  
        End Sub  
    End Class  
End Namespace

Sample output:

Default LoggingMode: UseParentSetting

New LoggingMode: 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.

Applies to

Share via