Could someone please, help me with this issue that I am having? I created an SSIS package that is generating a json file. Until now, each time i run the report, it overwrite the content of the txt file (which is what I want) but since 2 days ago, it is retaining the old reports. So, if I generated the reports 6 times, the notepad will contain all the 6 reports. I didn't change anything in the package.
Has someone encounter similar issue before, kindly advise on how to fix this.