OK I found how to do it.

Load the value of the location from the table into a variable.

And then use that variable as an expression for the connectionstring for the flatfile source.