Static FileName with date throughout whole process in ssis

Question

In my SSIS project, I am using a filename with a date (eg.Daily_20200706.CSV) and I need to schedule it at 11 PM (ist) and to complete the execution it's taking 3 to 4 hour and in between the filename is getting changed, when the system date is getting changed after 12 PM. So is there any solution for this to make it static the value of filename at the starting.

Answer 1

Yes.

1. Create a variable to hold your file name.
2. Populate the variable as the first task in your pipeline.
3. Use that variable everywhere you need the file name, instead of recalculating it from the current date every time you need the file name.