This topic has not yet been rated - Rate this topic

DTSForcedExecResult Enumeration

Specifies the execution result of a container when the container's ForceExecutionValue is set to true.

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

Syntax

C++

JScript

Copy

public enum DTSForcedExecResult

Members

	Member name	Description
	Failure	The execution result is set to Failure.
	Success	The execution result is set to Success.
	Completion	The execution result is set to Completion.
	None	The execution result is set to None. The event handler returns the actual execution result; the result is not forced.

Remarks

This enumeration is available to containers that need to force a specific execution result. You can use the ForceExecutionResult property on a container to test the use of checkpoints in a package. By setting ForceExecutionResult of a task or container to Failure, you can imitate real-time failure. When you rerun the package, failed task and containers will be rerun.

Examples

The following code example creates a new package, and explicitly sets the ForceExecutionResult on the Package to Failure.

Copy

Package pkg = new Package();
Pkg.ForceExecutionResult = DTSForcedExecResult.Failure;

Reference

Microsoft.SqlServer.Dts.Runtime Namespace

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)