use SSIS to move file if filename exists in a dbo.table.column else leave it alone

See more:

Visual-Studio

SSIS

T-SQL

I am using SSIS 2010. I have a folder with a number of files inside, and am required to:

1.check if filename exists in a table of data - so, is the filename also inside a column of data (this is a list of files that have met a certain criteria)

2.if the filename has a match then move it to another location, if not then leave it as is and then move onto the next file to check (foreachloop I guess).

Now I have done moves with variables (e.g. month.txt etc) but cannot figure out how to check against a table of data.

Can anyone help please? Thankyou