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.
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
To sensitize you for the risk of incomplete updates, you need to turn off the timeout warning explicitly.