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 Main;

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 Main;

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.