DSXchange

Hi ,
I would like to know how to convert a .xls excel work book containing two sheets to a .csv file using dataStage because the process has to be automated.
thanx.

Cannot be done using datastage, as far as i know. You need a third party tool to do that. Google it, you will have some useful finds.

Create a VB script on the Windows machine to effect the conversion. Invoke this via remote execution through an Execute Command activity in a job sequence.