Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

DTSForcedExecResult Enumeration

 

Applies To: SQL Server 2016 Preview

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)

public enum DTSForcedExecResult

Member nameDescription
Completion

The execution result is set to Completion.

Failure

The execution result is set to Failure.

None

The execution result is set to None. The event handler returns the actual execution result; the result is not forced.

Success

The execution result is set to Success.

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.

Legacy Code Example

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

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

Community Additions

Show:
© 2015 Microsoft