DSXchange

HI,
Is there prerequisites to extract excel files?
I am using unix based DS 9.1 version. Client is windows 7. I installed excel 2010 in client version. I am able too see the data in windows. I moved the file to unix machine through winscp. I am trying to extract the data using unstructured data stage. I mentioned filename along with filepath. i tried with range options as specify start row and specify the data range. range expressions. Column header. I tried with xls and xlsx formats.

Im getting error "file doesnot exist. Specify a valid file name".

Do i need to install or configure any library functions? Please guide.

You don't need to add any components to get this to work. I do recall that I had issues with parameter values inside the unstructured data stage; and you need to remember that paths used in this stage are relative to the server, not your DataStage client workstation.

- DataStage Server is installed on which flavor of Unix?
- Was the WINSCP file transfer of excel file done in Binary mode?
- In Unstructured Data Stage, is the path and the excel filename hard-coded Or is it parameterized?

I had issue with excel file while transfering the file to unix box. OS admin cleared the issue and then job works fine.

Some details please ... what was the issue and how did OS admin fix it?