• It's worth using a variable to hold the path for the flat file connection and then using Expressions in the flat file connection manager properties to set the connection string property to the variable value plus the file name in quotes (test for correctness with the Evaluate expression button).

    That way it is easier to change when you move to another server.