Refresh PowerPivot excel using SSIS
Install the SSIS_EXCEL_REFRESH.EXE in your ETL System and then you will find that component displaying in the SSIS Toolbox.
- Configure the EXCEL Refresh Tool
- Provide the Path where the Excel resides
- Set the Timeout for Refresh
- Run the ETL and check the Excel being refreshed.
You can check that by seeing the excel last modified date gets updated.
Refresh PowerPivot excel using SSIS was last modified: October 1st, 2017 by