Skip to Content
0
Former Member
May 04, 2017 at 01:10 PM

Reading data from Files using SAP BODS 4.2

262 Views Last edit May 04, 2017 at 11:14 AM 2 rev

Hi All,

I am a newbie to SAP BODS. Currently, i am trying to achieve a task which is as follows:

File paths and File names are maintained in a Config table.

What i want to achieve is to read the data from respective file paths, files which are prescribed in the Config table and load it in to a Target table.

My Config table structure is as follows:

Config_Id - Number (PK)

File_Path - Varchar

File_Name - Varchar

Example: If there are 3 entries in Config table pointing to 3 different files with each file having 10, 30 and 50 records respectively. So, After running the job, the target table should have (10+30+50) records.

Please let me know if such requirement is feasible using BODS. If yes, any direction on this would be of great help.