SAP BODS excel file open error
I am creating a very basic job which reads excel as an input and produces flat fle as output.
The excel is on my local machine.
but when I execute the job, I get below error.
12448 1620 FIL-080101 15/12/2014 14:05:15 Cannot open file <//Client/C$/311649/work/MLE - Demand Forecasting/sample data files/ProductService - ProductGroup.xls>. Check
Please can someone help what is wrong with my job.
Dirk Venken replied
As you say, the Excel file is on your local machine. DS runs on a server. If the server has no access to your local drive, and it normally hasn't, you'll have to copy your file.
Assuming you run DS on Windows, you basically have 2 options:
1/. Copy the file to a disk on the DS server
2/. Move your file to a share
When running DS on Linux, you will only have option 1.
You'll have to change the access path of the Excel in the data flow(s) where it is used to make sure DS can find it the new location.