IUiEtlObject.EtlTask

Syntax

Description

The EtlTask property determines the repository ETL task, to which it is required to get access.

Example

Executing the example requires a form with the UiEtlObject component named UiEtlObject1, EtlBox named EtlBox1 and EtlObjectPanelBox named EtlObjectPanelBox1. The ETL task with the ETLTask identifier is created in repository. Add links to the Etl, Metabase system assemblies. The example is a handler of the OnCreate event for the form.

Sub ETLBOX_SAMPLEFormOnCreate(Sender: Object; Args: IEventArgs);
Var
    MB: IMetabase;
Begin
    MB := MetabaseClass.Active;
    UiEtlObject1.EtlTask := MB.ItemById("ETLTask").Bind As IEtlTask;
    UiEtlObject1.Active := True;
    EtlBox1.Source := UiEtlObject1 As IEtlSource;
    EtlObjectPanelBox1.EtlBox := EtlBox1;
    EtlObjectPanelBox1.ShowOthers := False;
    EtlObjectPanelBox1.ShowMaps := False;
End Sub ETLBOX_SAMPLEFormOnCreate;

All components that are used to work with ETL task will be set up and connected at the form startup:

The repository ETL task with which to work will be specified for UiEtlObject1.
The UiEtlObject1 component will be specified as a data source for EtlBox1.
The EtlBox1 component, to which workspace new connectors can be added, will be specified for EtlObjectPanelBox1. The Transformers and Others panels will be hidden.