DTSExecStatus Enumeration
Contains values that indicate the current status of task execution or a container object at the time of the call.
Namespace: Microsoft.SqlServer.Dts.Runtime
Assembly: Microsoft.SqlServer.ManagedDTS (in Microsoft.SqlServer.ManagedDTS.dll)
| Member name | Description | |
|---|---|---|
| None | Task is idle (default value). | |
| Validating | Task is currently validating. | |
| Executing | Task is currently running. | |
| Completed | Task has completed executing with a success or failed result. | |
| Suspended | Task is currently suspended because the runtime has called suspend because of a breakpoint hit. | |
| Abend | The task experienced an internal error and terminated execution abnormally. |
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.
using System; using System.Collections.Generic; using System.Text; using Microsoft.SqlServer.Dts.Runtime; using Microsoft.SqlServer.Dts.Tasks.ScriptTask; namespace Package_API { class Program { static void Main(string[] args) { Package p = new Package(); p.InteractiveMode = true; p.OfflineMode = true; // Add a Script Task to the package. TaskHost taskH = (TaskHost)p.Executables.Add("STOCK:ScriptTask"); // Run the package. p.Execute(); // Review the results of the run. if (taskH.ExecutionResult == DTSExecResult.Failure || taskH.ExecutionStatus == DTSExecStatus.Abend) Console.WriteLine("Task failed or abended"); else Console.WriteLine("Task ran successfully"); } } }
Sample Output:
Task ran successfully
