I'm uploading a text-file with three different recordset substructures in any number and in variable sequence. I.e. a file could look like below:
Thus the File adapter settings are as follows:
Recordset Structure = structure 1,,structure 2,,structure 3.*
Recordset Sequence = Variable
This works fine, the problem is the file is huge and I would like to limit the number of records in each message by using the recordset per message parameter. But if you have a variable recordset sequence the whole message is regarded as one recordset. If I change to ascending sequence I get an unpredictable number of messages since a recordset change is only done every time the file "breaks the order" defined in the Recordset Structure. Basically I want each record to be regarded as a recordset so I can split the file up with a predictable number of record per message. Is there any work around possible?