DTSForcedExecResult Enumeration
Specifies the execution result of a container when the container's ForceExecutionValue is set to true.
Espacio de nombres: Microsoft.SqlServer.Dts.Runtime
Ensamblado: Microsoft.SqlServer.ManagedDTS (in microsoft.sqlserver.manageddts.dll)
Sintaxis
'Declaración
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. |
Notas
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.
Ejemplo
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
Plataformas
Plataformas de desarrollo
Para obtener una lista de las plataformas compatibles, vea Requisitos de hardware y software para instalar SQL Server 2005.
Plataformas de destino
Para obtener una lista de las plataformas compatibles, vea Requisitos de hardware y software para instalar SQL Server 2005.