ETL and Data Integration tools - Modern ETL software for everyone

I am utilizing a mask when downloading files via the FTP Operation. My mask is currently set at *.csv allowing me to download dynamic file names in a .csv format.

The problem I am having is when a customer posts a file with a file name in all CAPS, i.e. <filename>.CSV

The mask within the FTP Download Operation does not recognize the file because of the UPPERCASE .CSV Is there a way around this or can the FTP Download Operation be changed to not be case sensitive?

The mask function within the transformation reader is not case sensitive. Shouldn't this be the same?

Please advise.

Thank You!

Hmm.. Interesting question

Windows search is not case sensitive, FTP is and we can't change it
Our software does not perform any ftp searches we send "ls mask" command to the FTP server and download what ever the server returns

May be it is possible to make the server not case sensitive but it depends on the FTP server

However there is another solution you can use

Just create two FTP objects instead of one use *.csv mask for one and *.CSV for another

Mike

Mike,

Thanks for the response. I will add a secondary FTP Download Operation.

Thanks