See attached file.
I have a Package that read the files located in a specific path, and then it will process some data flows (compare data and insert data into SQL Database).
Before to process every dataflow, I need to verify if the file that my package is reading in that moment (User::FileName) has been storage (processed) in my table.
I don’t find the way to do it, if you see in my SSIS attached file. I insert a log of the file processed. But I don’t know how to compare or what Control Flow to use.