3 Replies Latest reply: Feb 13, 2012 9:14 AM by Francis vd Grijn RSS

    Load all files from FTP

    Partha Patra

      I have a problem loading all files of similar format (test_date.xls) from the FTP site. It works fine when I load files from the local drive.

       

      Working:

      LOAD *,FileName() as FILE_name

      FROM

      [C:\TEST\TEST_*.*]

      (biff, embedded labels, header is 2 lines, table is table$);

       

      Not Working

      LOAD *,FileName() as FILE_name

      FROM

      [ftp://test:test@ftp.site.com/TEST/TEST_*.*test@ftp.site.com/TEST/TEST_*.*]

      (biff, embedded labels, header is 2 lines, table is table$);

       

      The error given is "Unable to open the file...."

       

      However if I change the ‘not working’ code to individual files name (ex test_012010.xls), it works fine. It works for for all the indiviual data files.

      Is the *.* not compatible while reading from FTP ?

       

      Thanks