Reading xls file with DS ?
Posted: Wed May 30, 2007 3:33 am
hello everyone,
i would like to read an xls file with DS ? i try to do this with OLEDB component by creating an ODBC excel driver. DS succed to find the file with the test connection but there is still have this error on execution:
"DataStage Job 54 Phantom 4144
Program "DSP.Open": Line 122, Exception raised in GCI subroutine:
Access violation.
Attempting to Cleanup after ABORT raised in stage xls..MS_OLEDB_0
DataStage Phantom Aborting with @ABORT.CODE = 3"
Or sombody would have a solution with ODBC component ?
Thanks for your help (and sorry for my english :D )
i would like to read an xls file with DS ? i try to do this with OLEDB component by creating an ODBC excel driver. DS succed to find the file with the test connection but there is still have this error on execution:
"DataStage Job 54 Phantom 4144
Program "DSP.Open": Line 122, Exception raised in GCI subroutine:
Access violation.
Attempting to Cleanup after ABORT raised in stage xls..MS_OLEDB_0
DataStage Phantom Aborting with @ABORT.CODE = 3"
Or sombody would have a solution with ODBC component ?
Thanks for your help (and sorry for my english :D )