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.
Spazio dei nomi: Microsoft.SqlServer.Dts.Runtime
Assembly : Microsoft.SqlServer.ManagedDTS (in microsoft.sqlserver.manageddts.dll)
Sintassi
'Dichiarazione
Public Enumeration DTSLoggingMode
public enum DTSLoggingMode
public enum class DTSLoggingMode
public enum DTSLoggingMode
public enum DTSLoggingMode
Members
Member name | Description |
---|---|
Disabled | Logging is disabled. |
Enabled | Logging is enabled. |
UseParentSetting | Logging value is taken from the logging mode setting of the parent container. |
Osservazioni
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.
Esempio
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
Piattaforme
Piattaforme di sviluppo
Per un elenco delle piattaforme supportate, vedere Requisiti hardware e software per l'Installazione di SQL Server 2005.
Piattaforme di destinazione
Per un elenco delle piattaforme supportate, vedere Requisiti hardware e software per l'Installazione di SQL Server 2005.