DTSExecStatus Enum


包含指示在调用时任务执行或容器对象的当前状态的值。Contains values that indicate the current status of task execution or a container object at the time of the call.

public enum class DTSExecStatus
public enum DTSExecStatus
type DTSExecStatus = 
Public Enum DTSExecStatus


Abend 6

任务遇到了内部错误,执行已异常终止。The task experienced an internal error and terminated execution abnormally.

Completed 5

任务已完成执行,并返回成功或失败的结果。Task has completed executing with a success or failed result.

Executing 3

任务当前正在运行。Task is currently running.

None 1

任务空闲(默认值)。Task is idle (default value).

Suspended 4

因为运行时由于断点命中已调用挂起,任务当前被挂起。Task is currently suspended because the runtime has called suspend because of a breakpoint hit.

Validating 2

任务当前正在验证。Task is currently validating.


下面的代码示例演示了一种使用 DTSExecStatus 包中的枚举的方法。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.  
            // Review the results of the run.  
            if (taskH.ExecutionResult == DTSExecResult.Failure || taskH.ExecutionStatus == DTSExecStatus.Abend)  
                Console.WriteLine("Task failed or abended");  
                Console.WriteLine("Task ran successfully");  
Imports System  
Imports System.Collections.Generic  
Imports System.Text  
Imports Microsoft.SqlServer.Dts.Runtime  
Imports Microsoft.SqlServer.Dts.Tasks.ScriptTask  
Namespace Package_API  
    Class Program  
        Shared  Sub Main(ByVal args() As String)  
            Dim p As Package =  New Package()   
            p.InteractiveMode = True  
            p.OfflineMode = True  
            ' Add a Script Task to the package.  
            Dim taskH As TaskHost = CType(p.Executables.Add("STOCK:ScriptTask"), TaskHost)  
            ' Run the package.  
            ' Review the results of the run.  
            If taskH.ExecutionResult = DTSExecResult.Failure Or taskH.ExecutionStatus = DTSExecStatus.Abend Then  
                Console.WriteLine("Task failed or abended")  
                Console.WriteLine("Task ran successfully")  
            End If  
        End Sub  
    End Class  
End Namespace  

示例输出:Sample Output:

任务已成功运行Task ran successfully

Applies to