Case Sensitivity in downloading via FTP Operation

More
13 years 6 days ago #999 by Steve Vaughn
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!

Please Log in or Create an account to join the conversation.

More
13 years 6 days ago #1005 by admin
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
ETL Architect

Please Log in or Create an account to join the conversation.

More
13 years 5 days ago #1010 by Steve Vaughn
Mike,

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

Thanks

Please Log in or Create an account to join the conversation.