Reading data from Files using SAP BODS 4.2

[Former Member]

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.

[former_member187605]

Yes, you can. Use the sql built-in function in a DS script to retrieve file path and name from your table and load them into global variables. Use the global variables in the input file format definition in your data flow.

Embed script and data flow in a loop to iterate over all records in your config table.