Skip to Content
avatar image
Former Member

SAP BODS loading large csv

Hi,

I'm trying to load large csv file into a database table using SAP data services 14.2.7. I believe that my flat file definition is correct (comma as column separator, " for text), but when I execute my job it fails at row 22 000, because it does not correctly parse a column with comma inside. This column is correctly in quotations ("aaa, bbb") . When I move this row higher in the csv file, it gets processed correctly (as many others) and fails on some other similar case approximately at same row number. Do you have any idea how to fix this?

Thanks

Jan

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Aug 15, 2017 at 08:40 AM

    Hi

    Simple solution

    Split you source file to many by 20000 strings in each of it

    Regards

    Konsta

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi,

      thanks for suggestion. We are using CSV as a transfer method from the source system and we can not split all the incoming files. I have expected that this could be influenced by some parameter (cache, reader setup, etc ).

      Jan

  • avatar image
    Former Member
    Aug 29, 2017 at 11:03 AM

    This behavior is confirmed as bug by SAP.

    Add comment
    10|10000 characters needed characters exceeded