DTSExecStatus Enumeration
Contains values that indicate the current status of task execution or a container object at the time of the call.
Assembly: Microsoft.SqlServer.ManagedDTS (in Microsoft.SqlServer.ManagedDTS.dll)
| Member name | Description | |
|---|---|---|
| Abend | The task experienced an internal error and terminated execution abnormally. | |
| Completed | Task has completed executing with a success or failed result. | |
| Executing | Task is currently running. | |
| None | Task is idle (default value). | |
| Suspended | Task is currently suspended because the runtime has called suspend because of a breakpoint hit. | |
| Validating | Task is currently validating. |
The following code example shows one way of using the DTSExecStatus enumeration in a package. The method is called to determine the current status of the package at the time of the call.
Sample Output:
Task ran successfully
Show: