I have created an SSIS package that generates a JSON file. Previously, whenever I ran the report, it would overwrite the content of the text file, which was the desired behavior. However, for the past two days, the old reports are being retained. So, if I generated the reports six times, the notepad file would contain all six reports. I haven't made any changes to the package.
Has anyone experienced a similar issue before? I would greatly appreciate any advice on how to resolve this problem. suika game