Creating an FTP Report
Good morning all,
A question to see if anyone out there is already doing this.
We have built a custom BS based off of the EnsLib.FTP.InboundAdapter. We have our processes wake up (using the Scheduler), grab the files in the directory, stay awake for a while, and then go back to sleep.
Each file goes through on its own message. So we can trace each individual file and we know if it made it successfully or not.
What we would like to add is a status report email that creates a list of all the files sent in a "batch". So if the BS wakes up and processes 44 files, then there is one email or report with those 44 files instead of 44 separate emails.
I was thinking of using a SQL query against the Ens.MessageHeader table but I was wondering if anyone had other suggestions.
Thanks,
Tim