IEtlPlainFields.Item

Syntax

Item(Index: Integer): IEtlPlainField;

Parameters

Index. Field index.

Description

The Item property returns the object containing input or output field of ETL task object.

Example

Sub UserProc;
Var
    MB: IMetabase;
    EtlTask: IEtlTask;
    Join: IEtlPlainDataJoin;
    Input: IEtlPlainInput;
    Fields: IEtlPlainFields;
    Field: IEtlPlainField;
    s: String;
Begin
    MB := MetabaseClass.Active;
    EtlTask := MB.ItemById("ETL").Bind As IEtlTask;
    Join := EtlTask.Item(0) As IEtlPlainDataJoin;
    Input := Join.PlainInputs.Item(0);
    Fields := Input.Fields;
    Field := Fields.Item(0);
    s := Field.Id;
End Sub UserProc;

After executing the example the "s" variable contains an identifier of the first field of the first ETL task object. The type of ETL task object is Join. The repository object has the ETL identifier.