Enumeração DTSLoggingMode

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 (em Microsoft.SqlServer.ManagedDTS.dll)

Sintaxe

'Declaração
Public Enumeration DTSLoggingMode
'Uso
Dim instance As DTSLoggingMode

public enum DTSLoggingMode

public enum class DTSLoggingMode

type DTSLoggingMode

public enum DTSLoggingMode

Membros

	Nome do membro	Descrição
	Disabled	Logging is disabled.
	Enabled	Logging is enabled.
	UseParentSetting	Logging value is taken from the logging mode setting of the parent container.

Comentários

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.

Exemplos

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

Consulte também

Referência

Namespace Microsoft.SqlServer.Dts.Runtime