SSIS 2005 to export to Excel - refresh data every 4 hours
I have my SSIS package working and it runs ok the first time. What I cannot figure out is once the Excel spreadsheet is created the first time I cannot run the package again. I need a way to delete the whole file so it recreates with new data or delete all the data from the excel file and repopulate. I can seem to figure out this step.
My goal is basically have new data in Excel spreadsheet from my SQL database every 4 hours. I understand how to create my job on a schedule but the missing portion is deleting this excel file.