Symptom
- For two files with extensions .xls and .xlsx imported from an FTP server and read into a dataflow locally, jobs pulling .xls files fail if the sheet names used in the file format do not correspond with the sheet names used in the file format definition.
- Jobs with file extension .xlsx succeed regardless of the difference.
- Expected error:
- Error: OLE or COM processing error. Please make sure Microsoft Access Database Engine is properly installed: <'XXXXX$' is not a valid, while running a job that downloads a file via ftp file location and deletes it after processing
Read more...
Environment
- SAP Data Services 14.2.6.994
- Windows platforms
Product
SAP Data Services 4.2
Keywords
KBA , EIM-DS-EXE , Job Execution , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.