Martin Schoombee (2/14/2012)

---

If you're setting the filepath dynamically in this case, I would suggest that you set the "DelayValidation" property to false for both the flat file connection manager and the flat file source in your data flow.

What is probably happening here is that SSIS is trying to validate the connection before overwriting the variable's value, and hence the error message.