load multiple CDV files from ftp Directory

[Anonymous]

Hi all.

I´ve been strugling for the last two days with how can I load multiple CSV files from a given FTP directory and concatenate them into a table.

If I load a specific filename, I can load it without any problem,  but as soon as I use a star simbol to load every file with the same name (except for the date) it fails.

For example..

This Works:

Load * from

     'ftp://MyFTPUser:FTP_Password@IP_Address/Directory/Specific_File_Name.csv' 

     (txt, codepage is 1252, embedded labels, delimiter is ';', msq);

This doesn´t:

Load * from

     'ftp://MyFTPUser:FTP_Password@IP_Address/Directory/BR*.csv' 

     (txt, codepage is 1252, embedded labels, delimiter is ';', msq);

Any Ideas?

Thanks in advance.

[YoussefBelloum]

Hi,

it is loading some files when you put * ? or it is blocking from the start ?

[marcus_sommer]

It's not possible to use wildcards by FTP - you will always need a full-path or a batch-transfer, see: Re: Load new documents.

- Marcus

[Anonymous]

Hi Youssef, Thank you for your answer.

It´s blocking from the start.

I get a message sayinn that the file(?) could not be opened. Seing Marcu´s message below, ti should be some incompatibility between FTP protocol and wildcards.

Best Regards.

[Anonymous]

Hi Marcus,

Thank you for your answer. I´ll check the link you sent.

Best Regards.