IEtlPlainRecordSet.Count

Syntax

Count: Integer;

Description

The Count property returns the number of records in a flat 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.Count;

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 all records in the first data consumer field contain the number of data source records.