Skip to Content
avatar image
Former Member

Reading data from Files using SAP BODS 4.2

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • May 05, 2017 at 12:41 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded