Symptom
- Design a job that will read in multple Excel files using the wild card (*) filter, but only one file will be read in.
- Both files can be read in successfully separately.
- In more recent versions of Data Services and Windows Job server the job will fail with the following error:
Error "OLE or COM processing error. Please make sure Microsoft Access Database Engine is properly installed: <''worksheetname'' is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long.>" - In more recent versions of Data Services and Linux Job server the job will fail on a missing file path, but the Excel workbook name will be corrupted.
Read more...
Environment
SAP Data Services
Product
SAP Data Services 4.2
Keywords
wildcard , KBA , EIM-DS-EXE , Job Execution , EIM-DS , Data Services , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.