Skip to Content

Dynamic CSV Soruces for SAP Data Services 4.2 Load

Dear Community Members,

We are having data sources as .csv that we need to load into database on daily/hourly basis using SAP BODS 4.2.

Here, the source files (CSV) gets updated as either of one

  • Changing column positions in CSV sources
  • Addition/Deletion of columns in CSV files

In order to accommodate above changes we need to modify ETL regularly which is very time consuming.

Is there any option or approach in SAP BODS to automate above changes based on the column name in csv files & load the data correctly.

As per my understanding for these sources BODS will load the data based on the column positions instead of column names. We are looking if there can be any development or logic outside BODS which can help he automate the process and column mapping dynamically.

We are ok if someone would like to develop any code/script to fulfill above requirement even as paid assignment.

Please reach us for more details

Thanks in advance.

Satish Soni

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

0 Answers