Skip to Content

Processing Multiple Files simultaneously using BODS

Synopsis: This will be a step by Step tutorial on reading multiple files simultaneously using a single file format.

Two tab delimited flat files of identical format are available. They need to be extracted using BODI and the data needs to be pushed to the same table. The files source_1.txt and source_2.txt as shown in the below diagram are taken for demo purpose.


In the file format, mention both the file names separated by comma.


Using this file format, data from both the file formats are extracted at one go.


Similar Options: A filename containing a wildcard character can also be used to read multiple files. In the above example, instead of using “source_1.txt, source_2.txt” as filename, you can also use “source_*.txt” to extract multiple files with similar naming convention.

You must be Logged on to comment or reply to a post.
  • Debapriya,

    Thanks for the post, your example similar to what we do daily in our development environment. We are calling 44 text files using wild characters *.txt in filename field from a folder. Records of all the files are output to a table in sql server before transformation.


  • Hi Priya,

    Thanks for the Post, it is good Example ..

    I have one Question for you..

    I saw the BODS 3.0/4.0  Service packs, Can you please let me know what is the BODS 4.0 SP1,SP2,SP3 and SP4. It is added any new contents BODS 4.0 Service packs..

    Please replay me ASAP..



  • Hi DebaPriya,

    My Source is .CSV File and i have taken the faltfile format.

    There i have given the root path and the filename in the first time it is asking me for "OVERWRITE THE CURRENT SCHEMA WITH THE SCHEMA FROM THE FILE YOU SELECTED"  after 2 days i have taken the another file but this time it is not asking for the schema overwriting.

    Could you please assist me on this one.