Setting Up Event Handling

The development environment object and class containing implementation of event handlers for the ETL task are specified on the Event Handling page.

To call the ETL task properties, follow one of the steps:

Select the Task > Properties item in the ETL task main menu.
Press CTRL+P.

By clicking the Next button, go to the Event Handling wizard page.

Select a development environment object in the Unit drop-down list, select a class that contains implementation of event handlers for ETL task in the Class drop-down list. A list of handler classes contains all classes inherited from the EtlTaskExecutionEvents class.

If required, an event handler can be created automatically by clicking the Create button. In this case a Fore unit or Fore.NET assembly with unit is created. Unit code is generated automatically and opened in the development environment.

Event handler class can be included into the designer opened at each class initialization. The designer must not contain any parameters. If the class has several designers without parameters, the first one is called (located above the others in the code). If the designer is used to handle events of .NET assembly, it should be claimed with the Public access modifier.

Class EventsClass: EtlTaskExecutionEvents
    Constructor Create;
    Begin

    End Constructor Create;

    Public Sub OnStartTask(Task: IEtlTask);
    Begin
    End Sub OnStartTask;

    Public Sub OnEndTask(Task: IEtlTask; Duration, TotalRec, ErrorRec: Integer);
    Begin
    End Sub OnEndTask;

    Public Sub OnStartBlock(Task: IEtlTask; Object: IEtlObject);
    Begin
    End Sub OnStartBlock;

    Public Sub OnEndBlock(Task: IEtlTask; Object: IEtlObject; Duration: Integer; TotalRecIn, TotalRecOut, ErrorRec: IDictionary);
    Begin
    End Sub OnEndBlock;

    Public Sub OnProgress(Task: IEtlTask; Progress: Integer);
    Begin
    End Sub OnProgress;

    Public Sub OnError(Task: IEtlTask; Object: IEtlObject; Excep: IException);
    Begin
    End Sub OnError;
End Class EventsClass;

Imports Prognoz.Platform.Interop.Etl;
Imports Prognoz.Platform.Interop.ForeSystem;
Imports System.Collections;

Public Class EventsClass: EtlTaskExecutionEventsClass
    Public Constructor Create();
    Begin
    End Constructor;

    Public Override Sub OnStartTask(Task: IEtlTask);
    Begin
    End Sub OnStartTask;

    Public Override Sub OnEndTask(Task: IEtlTask; Duration, TotalRec, ErrorRec: Integer);
    Begin
    End Sub OnEndTask;

    Public Override Sub OnStartBlock(Task: IEtlTask; Object: IEtlObject);
    Begin
    End Sub OnStartBlock;

    Public Override Sub OnEndBlock(Task: IEtlTask; Object: IEtlObject; Duration: Integer; RecIn, RecOut, ErrorRec: IDictionary);
    Begin
    End Sub OnEndBlock;

    Public Override Sub OnProgress(Task: IEtlTask; Progress: Integer);
    Begin
    End Sub OnProgress;

    Public Override Sub OnError(Task: IEtlTask; Object: IEtlObject; Excep: Exception);
    Begin
    End Sub OnError;
End Class EventsClass;