IEtlPlainRecordSet.Add

Syntax

Add: Integer;

Description

The Add method adds a record into data set.

Example

Sub UserSub(Input: IEtlPlainRecordSets; Output: IEtlPlainRecordSets);
Var
    RecordSetIn, RecordSetOut: IEtlPlainRecordSet;
    i: Integer;
Begin
    RecordSetIn := Input.Item(0);
    RecordSetOut := Output.Item(0);
    For i := 0 To RecordSetIn.Count - 1 Do
        RecordSetOut.Add;
        RecordSetOut.Item(i).Value(0) := RecordSetIn.Item(i).Value(0);
    End For;
End Sub UserSub;

This example is a custom unit macro that is used to transform data in ETL task. After executing the ETL task the equal number of records is created in a data consumer as well as in a data provider.