IEtlPlainFields.Item

Syntax

Item(Index: Integer): IEtlPlainField;

Parameters

Index is a field index.

Description

The Item property returns an 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 this example the "s" variable contains an identifier of the first field of the first ETL task object. Type of ETL task object is Join. Repository object has the ETL identifier.