IDTSEvents Interface


Defines a set of events used by the TaskHost on behalf of a task.

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

public interface IDTSEvents

System_CAPS_pubmethodOnBreakpointHit(IDTSBreakpointSite, BreakpointTarget)

Called when a breakpoint is hit within a task.

System_CAPS_pubmethodOnCustomEvent(TaskHost, String, String, Object[], String, Boolean)

Called by tasks to raise custom task-defined events.

System_CAPS_pubmethodOnError(DtsObject, Int32, String, String, String, Int32, String)

Called by a task or container when an error occurs.

System_CAPS_pubmethodOnExecutionStatusChanged(Executable, DTSExecStatus, Boolean)

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

System_CAPS_pubmethodOnInformation(DtsObject, Int32, String, String, String, Int32, String, Boolean)

Called any time the task is required to provide information.

System_CAPS_pubmethodOnPostExecute(Executable, Boolean)

Called immediately after the execution logic of the task completes. This event is raised by a task or container immediately after it runs.

System_CAPS_pubmethodOnPostValidate(Executable, Boolean)

Called immediately after the validation logic of the task completes. This event is raised by a task after the task is validated.

System_CAPS_pubmethodOnPreExecute(Executable, Boolean)

Called when a task is about to execute. This event is raised by a task or a container immediately before it runs.

System_CAPS_pubmethodOnPreValidate(Executable, Boolean)

Called when the actual validation logic of the task starts. This event is raised when the validation of the task host or container begins.

System_CAPS_pubmethodOnProgress(TaskHost, String, Int32, Int32, Int32, String, Boolean)

Called to update progress about task execution.


Called at any juncture in task processing where it is feasible to cancel execution. This event is raised by tasks and containers to determine whether they should stop running.


Called by the task host when it fails.

System_CAPS_pubmethodOnVariableValueChanged(DtsContainer, Variable, Boolean)

Called by the run-time engine. It is not called by tasks.

System_CAPS_pubmethodOnWarning(DtsObject, Int32, String, String, String, Int32, String)

Called any time the task is in a state that does not justify an error, but does warrant alerting the client.

For each method, there is a related object in the DtsEventHandlers collection that handles the event. If the event is disabled, the object will not execute and will return false. If the object does not handle the event at the local level, the event is escalated to the parent container to be handled.

These methods provide indexes into the events collection for the corresponding event handler.

Return to top