Skip to Content
author's profile photo Former Member
Former Member

how to load multiple csv files automatically in one batch job

Posted on Jun 22, 2004 at 03:30 PM 154 Views

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.

BW (SAP Business Warehouse) SAP TechEd SAP NetWeaver User Interface
Add comment
10|10000 characters needed characters exceeded

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jun 23, 2004 at 12:32 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member
      Jun 23, 2004 at 12:31 PM

      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

  • author's profile photo Former Member
    Former Member
    Posted on Jun 29, 2004 at 03:44 PM

    Hi Heike,

    Thanks for this good hint. It works fine.

    Regards

    Andreas

    Add comment
    10|10000 characters needed characters exceeded