BusinessObjects Board

How to call Multiple Excel files from particular sheet in DS

dataservices job design
#1

Hi Experts,

I have a requirement to call Multiple Excel files ( Around 150 Excel files ) and load data into the Teradata table. In each Excel files, we have 3 sheets. I have to extract data from sheet1 and do not want from the rest of 2 sheets. And all files should run one by one automatically while executing the job.

Please help us how can we approach this in SAP BODS. Any help is really appreciated.

Attached the smaple excel file

Thanks,
Veni
Call Mutilple excel.PNG

ursfriend77 (BOB member since 2011-03-02)