SAP Knowledge Base Article - Preview

2417786 - File with extension .xls not deleted after processiong via FTP file location in Designer, SAP Data Services 14..x

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 , Data Services 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.