- 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
- SAP Data Services 18.104.22.1684
- Windows platforms
SAP Data Services 4.2
KBA , EIM-DS-EXE , Data Services Job Execution , Problem
About this pageThis 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.