Error when DS loads Excel data into table using FTP

[venkataramana_paidi]

Hi ,

I want to load excel file from the FTP. I have created one folder FTP called test  and kept the excel file .

But when I am trying load excel file into table  or view the data from excel file  it is throwing error like

FTP could not transfer file </TEST/EMP.XLSX> from host <www.0catch.com>: <>. Ensure that the FTP relative path for the SAP server working directory is set correctly such that the data file is accessible to the FTP program.  Also, ensure that the target path, where the transferred file is written to, is correct.

I am using DS 4.1 SP2.

Please help me how to resolve this issue.

Thanks & Regards,

Ramana.

[former_member136842]

Hi,

the Username looks strange. Are you sure this one is correct?

Can you pass the URL into a Browser please and check if you are able to download the file?!

Regards

-Seb.

[venkataramana_paidi]

Hi Sebastian ,

Yes  I uploaded the file using filezilla . I can import from ftp also.

Please find the below screenshot.

Thanks & Regards,

Ramana

[former_member136842]

Hi,

just in case - try to write the Filename in the exact case as we can se it here in Data Services. So not "EMP.XLSX" but "EMP.xslx"

Regards

-Seb.

[venkataramana_paidi]

Hi Sebastian ,

I have changed extension from XLSX to xlsx  in the data access tab of the excel format.But it is throwing the same error. Please find the below screenshot for error.

Thanks & Regards,

Ramana.