Click to Rate and Give Feedback
MSDN
MSDN Library
SQL Server
SQL Server 2008
Technical Reference
 DTSForcedExecResult Enumeration
Other versions are also available for the following:
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)
Visual Basic (Declaration)
Public Enumeration DTSForcedExecResult
C#
public enum DTSForcedExecResult
C++
public enum class DTSForcedExecResult
J#
public enum DTSForcedExecResult
JScript
public enum DTSForcedExecResult
Member nameDescription
CompletionThe execution result is set to Completion.
FailureThe execution result is set to Failure.
NoneThe execution result is set to None. The event handler returns the actual execution result; the result is not forced.
SuccessThe 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.


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

C#
Package pkg = new Package();
Pkg.ForceExecutionResult = DTSForcedExecResult.Failure;
Visual Basic
Dim pkg As Package = New Package() 
Pkg.ForceExecutionResult = DTSForcedExecResult.Failure

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server.

Target Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server.
Tags What's this?: Add a tag
Community Content   What is Community Content?
Add new content RSS  Annotations
Processing
© 2008 Microsoft Corporation. All rights reserved. Terms of Use  |  Trademarks  |  Privacy Statement
Page view tracker