I have an SSIS package that has a foreach loop container with a data flow task inside which loops files inside a folder to store records of text files in a SQL table. I am required to add an "Execute SQL Task" before the data flow task which should deletes records if a file is being processed again to avoid duplicate records. My connection manager is an OLE DB. How would I be able to achieve this?
Any help would be greatly appreciated.