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 ?