Share via

Facebook x.com LinkedIn Email

DtsContainer.MaximumErrorCount Property

Gets or sets an Integer value that indicates the maximum number of errors that can occur before the DtsContainer object stops running.

Namespace: Microsoft.SqlServer.Dts.Runtime
Assembly: Microsoft.SqlServer.ManagedDTS (in Microsoft.SqlServer.ManagedDTS.dll)

Syntax

'Declaration
Public Property MaximumErrorCount As Integer
 Get
 Set
'Usage
Dim instance As DtsContainer
Dim value As Integer
value = instance.MaximumErrorCount
instance.MaximumErrorCount = value
public int MaximumErrorCount { get; set; }
public:
property int MaximumErrorCount {
 int get ();
 void set (int value);
}
member MaximumErrorCount : int with get, set
function get MaximumErrorCount () : int
function set MaximumErrorCount (value : int)

Property Value

Type: System.Int32
An Integer that indicates the maximum number of errors allowed. The default value of this property is 1.

Examples

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


  • Last updated on 2011年05月23日