Project Description
SSIS Excel Refresh Task refreshes an whole Excel-File or single Queries inside your workbook.

With this SSIS Task you can refresh a whole Excel file or single queries of your Excel-sheet inside the workflow.

SSIS Excel Refresh Task SSIS Excel Refresh Task SSIS Excel Refresh Task

Because the component does not get back a result when the update process is finish, the component works with a timeout. You can define the timeout by yourself or you can calculate the timeout based on the file size. The last solution works best for growing files.

To sensitize you for the risk of incomplete updates, you need to turn off the timeout warning explicitly.

Last edited Apr 10, 2014 at 11:31 AM by Tillmann, version 12