Skip to Content
0

Reading data from Files using SAP BODS 4.2

May 04, 2017 at 01:10 PM

62

avatar image
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.

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

1 Answer

Dirk Venken
May 05, 2017 at 12:41 PM
0

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.

Share
10 |10000 characters needed characters left characters exceeded