Hi everyone, I just started working with SSIS packages. For a project, I need to generate a csv file output and name it dynamically. The idea is to create a file every month on 20th with data which goes a month. Format should look like: ABC_20_JUNE_2021_to_20_JULY_2021.
I have worked out the part to generate current date, for example, 20 JULY_2021. But can't think of how I can generate 30 days back date dynamically every time. Any comment is appreciated.
