I assume the underlying data is stored in an Excel sheet?
In SSIS, you need to specify the Excel file and the sheet to import the data.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP