Split the file in the batches of 1000 records

[Former Member]

Hi,

I need to read a fixed length file from SAP system and then have to send the file which is combination of a huge number of records (e.g 100000) in the batches of 1000 records each to the target system.The target system which is a third party has a constraint of accepting only 1000 records in a file.

What is the best approach we may use here to split the file in the batches of 1000 records and then send the file to the target.

Kindly suggest.

Thank You.

Regards,

Indu Khurana.

[Former Member]

The adapter will will take care this and split the input file (message) into smaller message batches (set to the number of records defined by you, say 1000). Each of these smaller batches will be processed as per your design and configuration. For example a straight through sender and receiver will have the sender splitting the input file into batches of 1000 messages which will be delivered to your receiver. You could also add a timestamp or the like to stop the file being overwritten at the destination.

Regards,

Mike

[Former Member]

Indu,

If using the File sender adapter, try to selected File Content Conversion as the Message Protocol and then make an entry under Recordsets per Message to split an input file into several messages.

Regards,

Mike

[Former Member]

Thanks Mike for your reply.

But how exactly the split is to be done?

Indu