Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
DTSExecStatus Enumeration
Collapse the table of content
Expand the table of content

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)

public enum DTSExecStatus

Member nameDescription
AbendThe task experienced an internal error and terminated execution abnormally.
CompletedTask has completed executing with a success or failed result.
ExecutingTask is currently running.
NoneTask is idle (default value).
SuspendedTask is currently suspended because the runtime has called suspend because of a breakpoint hit.
ValidatingTask 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.

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

Community Additions

ADD
Show:
© 2015 Microsoft