Skip to Content
0
Apr 19, 2010 at 08:17 AM

Extract .xls file from an FTP site

51 Views

Hi everyone,

Can anyone assist with this, I'm trying to extract an .xls file from a FTP site. The system I'm currently working on has no SAP application installed, we are using Microsoft SQL server as the target database and there is an FTP site which contains the .xls/.csv files and Data services as a ETL tool. The error I'm getting is 'FTP could not transfer file from host <www.servername.com>: . Please 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.'

Do I need to have SAP installed to use this functionality?

Currently to make this work, I wrote a .CMD file to do the GET ftp code and I then call this with a DI script and it works perfectly. Isn't there a way I can do this independant of the .CMD?

I'm sorry for bring this up again, I know I had a similar thread before. The reason why I closed it is that I did it using .CMD, I would prefer if I can do it with DI without using .CMD.

Thank all for your help.

Kind regards,

Edited by: gsecure on Apr 19, 2010 10:26 AM

Edited by: gsecure on Apr 21, 2010 11:08 AM