You could put the name of the file into a Package Variable and then reference the package variable to set the Excel Source using an Expression in the connection manager.