I have a job on SSIS that runs every 1st of the Month and puts a CSV file into a folder that is then grabbed by another process, this process then checks the file name date is the same as the header date in the file. On change of the year the job failed and reported the file name date was different to the one in the file.
The file name date was the first of January 2021, and the date in the file was as it should be 01/01/2022.
I ran the job manually again and it was fine. Can anyone suggest why the automated run of the job, which happened on the 01/01/2022 at 07:30 (when I was off) created a file with the previous Year's first of January date?