on 01-29-2015 10:43 AM
I have flat file as my target in sap bods jobs.
I need to split file each time it exceeds 500 MB.
what could be the best way to do this?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
We handle the similar scenario by introducing row numbers to the target table and then split them into multiple files using While Loop.
but is there anyway to find the size of the file. how do I know exactly when the file has reached 500 MB size?
Well , usually we go by the record count.When the record count reaches the limit , we start splitting the file.
There is a way which is described in below video
SAP BODS - Dynamic File Splitting - YouTube
But I do not want to use template tables.Anyone knows if it can be splited without use of template table.
Better use an external utility tool. Cygwin is a good tool with lot of features and can be used to split the files externally.
Yes, you can easily combine the logic of both dataflows into one, making the template table redundant.
But you'll never be able to get the exact same results you're looking for. In the video, as file split is done on number of records, not on size.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.