Exporting data to Excel Spreadsheets with Refresh using SSIS

Data Warehouse Refresh in SSIS

Refresh the tables in datawarehouse using CDC.
After you have applied CDC on specific tables