FileSystem-Task.JPG

<div>
Perfect. &nbsp;I used File system Task. I put step on the first line of my Control Flow and worked.
</div>


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

<div>
<div class="content wysiwyg-content">
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. <br />
<br />
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.
</div>
</div>


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.

SSIS 2005 to export to Excel - refresh data every 4 hours

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.