Here's the general approach I use:
1. Set a variable for the path (folder). Learned early on to separate the path because paths that I thought would NEVER change did. :-P
2. Set a variable for the file name. This is often an expression to allow including the run date or other important but changing aspects of the file name.
3. Set a variable for the full file name. This is always an expression of @Path + @FileName.
4. Set the expression for the connection string to @FileNameFull for the flat file connection manager via the properties window, expressions section.
I think that's what you're doing but I'm not positive.
Ive added the file path in with the file name that is only used to create the CSV files and it seems to have dont the trick. It means that if I change the folder I have to go into the SQL View I have created to alter it but at least it is working.
Thank you, that list was really helpful.:-)