Dear Experts,
My requirement is I need to bring the data from Src (SrcCoulmn: DataTime) for the Last 2 years based on Today's date with the start date/Month is 01-Apr-YYYY (Last year).
Eg: If Today's Date (18-Aug-2021). I need data from 01-April-2020 till Today's Date
How this can be done in Tsql and in SSIS.
Much Appricated.
Cheers
San