• csharp
• jscript
• c++
• vb
• vj#
• fsharp

Syntax

'Declaration
Public Property FailParentOnFailure As Boolean
 Get
 Set
'Usage
Dim instance As DtsContainer
Dim value As Boolean
value = instance.FailParentOnFailure
instance.FailParentOnFailure = value

public bool FailParentOnFailure { get; set; }

public:
property bool FailParentOnFailure {
 bool get ();
 void set (bool value);
}

member FailParentOnFailure : bool with get, set

function get FailParentOnFailure () : boolean
function set FailParentOnFailure (value : boolean)

Remarks

If FailParentOnFailure is true and the execution result of a container is failure, the execution result of failure is assigned to the parent container. For more information, see Restarting Failed Packages by Using Checkpoints.

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

See Also

Reference