DTSForcedExecResult Enumeration
Specifies the execution result of a container when the container's ForceExecutionValue is set to true.
Espace de noms: Microsoft.SqlServer.Dts.Runtime
Assembly: Microsoft.SqlServer.ManagedDTS (in microsoft.sqlserver.manageddts.dll)
Syntaxe
'Déclaration
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. |
Notes
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.
Exemple
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
Plateformes
Plateformes de développement
Pour obtenir la liste des plateformes prises en charge, consultez Configuration matérielle et logicielle requise pour l'installation de SQL Server 2005.
Plateformes cibles
Pour obtenir la liste des plateformes prises en charge, consultez Configuration matérielle et logicielle requise pour l'installation de SQL Server 2005.