We have a scenario where we get multiple files as input at a SFTP server and we need to read all those files and send emails. We tried to use Transfer File activity, it could read all the files but while processing the data in further activities only the last file record are considered.
The file nomenclature is Marketinglist_<n>.csv where n is an integer.
so lets say we have files marketinglist_1.csv, marketinglist_2.csv so on. Each file may have varied number of records. we can to send email to each of these records.How can we achieve that?