YarHad (2/26/2013)
Hi All,Is there way to in SSIS to delete the contents of a text file before importing data into it? Just how you can truncate a table before adding data to it. Is it possible in SSIS?
Thanks
Sure. Just make sure that the 'Overwrite data in the file' box is checked in the flat file destination editor.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.