• You can enter a dynamic destination using an expression https://www.simple-talk.com/sql/ssis/working-with-property-expressions-in-sql-server-integration-services/

    Leave your existing settings as they are, the destination will be changed by the expression on execution.

    You'll need a variable which is populated by reading the file date somehow, probably use powershell, then use the variable in the OLE DB expression