Converting .xls to .csv using datastage

sdfasih · Post by **sdfasih** » Wed Oct 11, 2006 9:37 am

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.

DSguru2B · Post by **DSguru2B** » Wed Oct 11, 2006 9:40 am

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.

ray.wurlod · Post by **ray.wurlod** » Wed Oct 11, 2006 3:03 pm

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.