TechNet
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

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
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.

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

Return to top
Show:
© 2016 Microsoft