SAP Knowledge Base Article - Preview

2669116 - Excel file object with wild card filter only reads one file - Data Services

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.