DtsContainer.LoggingMode Property
Gets or sets a valid value from the DTSLoggingMode enumeration that indicates the logging mode of the container.
네임스페이스: Microsoft.SqlServer.Dts.Runtime
어셈블리: Microsoft.SqlServer.ManagedDTS (in microsoft.sqlserver.manageddts.dll)
구문
‘선언
Public Property LoggingMode As DTSLoggingMode
public DTSLoggingMode LoggingMode { get; set; }
public:
property DTSLoggingMode LoggingMode {
DTSLoggingMode get ();
void set (DTSLoggingMode value);
}
/** @property */
public DTSLoggingMode get_LoggingMode ()
/** @property */
public void set_LoggingMode (DTSLoggingMode value)
public function get LoggingMode () : DTSLoggingMode
public function set LoggingMode (value : DTSLoggingMode)
속성 값
Returns a DTSLoggingMode enumeration.
주의
The logging mode can be enabled or disabled on a specific container or task, or you can inherit the logging mode value from the parent container when this value is set to UseParentSetting.
예
The following code example creates a Package, which is a class that inherits from DtsContainer. The Package shows the use of several inherited properties.
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)
{
Application app = new Application();
Package pkg = new Package();
// Package name must be assigned.
pkg.Name = "My DtsContainer inheritance test package";
// Display the values that manually assigned.
Console.WriteLine("Package Name: {0}", pkg.Name);
// Packages are assigned the following default values when created.
Console.WriteLine("Package ID: {0}", pkg.ID);
Console.WriteLine("FailPackageOnFailure: {0}", pkg.FailPackageOnFailure);
Console.WriteLine("FailParentOnFailure: {0}", pkg.FailParentOnFailure);
Console.WriteLine("Locale ID: {0}", pkg.LocaleID);
Console.WriteLine("Is DefaultLocaleID? {0}", pkg.IsDefaultLocaleID);
Console.WriteLine("Isolation Level: {0}", pkg.IsolationLevel);
Console.WriteLine("LoggingMode: {0}", pkg.LoggingMode);
Console.WriteLine("MaximumErrorCount: {0}", pkg.MaximumErrorCount);
Console.WriteLine("TransactionOption: {0}", pkg.TransactionOption);
}
}
}
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 app As Application = New Application()
Dim pkg As Package = New Package()
' Package name must be assigned.
pkg.Name = "My DtsContainer inheritance test package"
' Display the values that manually assigned.
Console.WriteLine("Package Name: {0}", pkg.Name)
' Packages are assigned the following default values when created.
Console.WriteLine("Package ID: {0}", pkg.ID)
Console.WriteLine("FailPackageOnFailure: {0}", pkg.FailPackageOnFailure)
Console.WriteLine("FailParentOnFailure: {0}", pkg.FailParentOnFailure)
Console.WriteLine("Locale ID: {0}", pkg.LocaleID)
Console.WriteLine("Is DefaultLocaleID? {0}", pkg.IsDefaultLocaleID)
Console.WriteLine("Isolation Level: {0}", pkg.IsolationLevel)
Console.WriteLine("LoggingMode: {0}", pkg.LoggingMode)
Console.WriteLine("MaximumErrorCount: {0}", pkg.MaximumErrorCount)
Console.WriteLine("TransactionOption: {0}", pkg.TransactionOption)
End Sub
End Class
End Namespace
Sample Output:
Package Name: My DtsContainer inheritance test package
Package ID: {2C2FAA96-35BA-4C5E-A39A-C5D7D30A0D79}
FailPackageOnFailure: False
FailParentOnFailure: False
Locale ID: 1033
Is DefaultLocaleID? False
Isolation Level: Serializable
LoggingMode: UseParentSetting
MaximumErrorCount: 1
TransactionOption: Supported
스레드 보안
Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.
플랫폼
개발 플랫폼
지원되는 플랫폼 목록은 SQL Server 2005 설치를 위한 하드웨어 및 소프트웨어 요구 사항을 참조하십시오.
대상 플랫폼
지원되는 플랫폼 목록은 SQL Server 2005 설치를 위한 하드웨어 및 소프트웨어 요구 사항을 참조하십시오.
참고 항목
참조
DtsContainer Class
DtsContainer Members
Microsoft.SqlServer.Dts.Runtime Namespace