Share via

  • Article

IDTSEvents.OnExecutionStatusChanged Method

Called by a task or container when its execution status changes.

Namespace:  Microsoft.SqlServer.Dts.Runtime
Assembly:  Microsoft.SqlServer.ManagedDTS (in Microsoft.SqlServer.ManagedDTS.dll)

Syntax

'Declaration
Sub OnExecutionStatusChanged ( _
    exec As Executable, _
    newStatus As DTSExecStatus, _
    ByRef fireAgain As Boolean _
)
'Usage
Dim instance As IDTSEvents
Dim exec As Executable
Dim newStatus As DTSExecStatus
Dim fireAgain As Boolean

instance.OnExecutionStatusChanged(exec, _
    newStatus, fireAgain)

void OnExecutionStatusChanged(
    Executable exec,
    DTSExecStatus newStatus,
    ref bool fireAgain
)

void OnExecutionStatusChanged(
    Executable^ exec, 
    DTSExecStatus newStatus, 
    bool% fireAgain
)

abstract OnExecutionStatusChanged : 
        exec:Executable * 
        newStatus:DTSExecStatus * 
        fireAgain:bool byref -> unit 

function OnExecutionStatusChanged(
    exec : Executable, 
    newStatus : DTSExecStatus, 
    fireAgain : boolean
)

Parameters

  • fireAgain
    Type: System.Boolean%
    A Boolean that indicates this should continue firing or stop firing. A value of true indicates that it should continue firing.

Remarks

The following table shows the values that newStatus will contain:

newStatus

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 of a breakpoint hit.

Validating

Task is currently validating.