共用方式為


DTSForcedExecResult Enumeration

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

命名空間: Microsoft.SqlServer.Dts.Runtime
組件: Microsoft.SqlServer.ManagedDTS (in microsoft.sqlserver.manageddts.dll)

語法

'宣告
Public Enumeration DTSForcedExecResult
public enum DTSForcedExecResult
public enum class DTSForcedExecResult
public enum DTSForcedExecResult
public enum DTSForcedExecResult

Members

Member name Description
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.

範例

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;
Dim pkg As Package = New Package() 
Pkg.ForceExecutionResult = DTSForcedExecResult.Failure

平台

開發平台

如需受支援的平台清單,請參閱<安裝 SQL Server 2005 的硬體和軟體需求>。

目標平台

如需受支援的平台清單,請參閱<安裝 SQL Server 2005 的硬體和軟體需求>。

請參閱

參考

Microsoft.SqlServer.Dts.Runtime Namespace