1 Reply Latest reply: Apr 27, 2016 3:32 AM by Marcus Sommer RSS

    Incremental load when reading files via FTP?

    sarita sharma

      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.

       

      Thanks