I am trying to read files via FTP from a particular location. Each month a new file will be dropped in this location. I would like to read this to perform incremental load and append to existing qvd each month.
Files are in csv format. FTP has username/Password information.
How do I check if the files exist in the a certain location ?
I was using
FOR Each HFile in filelist ('ftp://Username:Password@SERVERNAME/*.csv')
but it fails to read the file.
Any help is appreciated.
The ftp-protocoll don't support wildcards or any file-functions like filelist. But there are workarounds for it, see for example: