Link to home
Start Free TrialLog in
Avatar of allenkent
allenkentFlag for United States of America

asked on

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.
Avatar of Deepak Chauhan
Deepak Chauhan
Flag of India image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of allenkent


Perfect.  I used File system Task. I put step on the first line of my Control Flow and worked.