Skip to Content
0

SAP BODS loading large csv

Aug 14, 2017 at 09:33 AM

71

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Kanstantin Chernichenka Aug 15, 2017 at 08:40 AM
0

Hi

Simple solution

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

Regards

Konsta

Show 1 Share
10 |10000 characters needed characters left 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

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

This behavior is confirmed as bug by SAP.

Share
10 |10000 characters needed characters left characters exceeded