Hi @Nitesh ,
If you have access to the Excel path which is located there in SharePoint library, you can set this path in Excel Source Connection Manager.
Details please refer: export-sharepoint-excel-sheet-to-sql-using-ssis
You may also download the excel file with SSIS and then import data from the file, see this.
In addition, use third-party tools is also a workaround, take a carefully reference here.
Regards,
Zoe
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues October