how to load multiple csv files automatically in one batch job

[Former Member]

Hi all,

Is there a way to load multiple csv files automatically?

We have to load over 200 flatfiles into BW and don't want to generate over 200 Infopackages.

I'd be grateful for any advice.

[Former Member]

Hi Heike,

Thanks for this good hint. It works fine.

Regards

Andreas

[Former Member]

When you say that you are loading from csv files in batch means I presume that these files are staged on the BW application server (UNIX level).

You can use a UNIX command (ex: CAT FILE-A FILE-B > FILE-FINAL) by which you can write all the files info into one final csv file, so that from BW you can extract complete data in one load.

hope this helps...

thanks

Sravan

[Former Member]

Thank you for your message,

but the size of one file is over 100MB. So, if we merge the files, we get a buffer overrun on the application server.

Preferable we search a solution to start one InfoPackage in a loop with changing the "path string" on each loop until all files are inserted into BW.

Kind regards

Andreas

[Former Member]

Hi,

you might want to check the BAPI BAPI_IPAK_CHANGE

or you could create a routine for the filename and use the memory to pass information of the filename to your routine

Heike