I am trying to perform data validations on delta files that have been loaded to an FTP server. I downloaded the list of files which are zip files - each zip file contains one csv file. All csv files follow an identical format structure.
I would like to be able to mass read in this directory so that I can read in all records from all files into one master table. The wildcard option within the Input tool does not help me since the csv files are all within these zip files. Options?
This issue sounds similar to yours and seems to have been solved. Have you tried this yet?