See attach.

And image says more than a word

It was kind of hard to find out the answer. Even know its something easy, but I never use this before. I used Tim Mitchell recommendation as you suggested. But I didn’t know how to control the names that were inserted in my sql table.

So, take a look at the attach and see the Data Flow of the Control Flow called “Compare if File exists in Log Table”

Regards,