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

• exec
  Type: Microsoft.SqlServer.Dts.Runtime.Executable
  The task raising the event.

• newStatus
  Type: Microsoft.SqlServer.Dts.Runtime.DTSExecStatus
  The current status of the executable.

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

See Also

Reference

IDTSEvents Interface

Microsoft.SqlServer.Dts.Runtime Namespace