I am new to ssis. I want to schedule a job to create a csv file daily. So each day, the existing file should be deleted and I want to create a new csv file. Could you please help me with this?
As for deleting existing file, the flat file connection properties should have a tick box to overwrite the existing file. If the file is not locked by another process like Excel that should be sufficient to ensure the old one is replace by the new one
If you need more guidance on how to build the package you can have a look at the below link