how to Import excel file data from TEAMS online (sharepoint) with SSIS

Nitesh 1 Reputation point
2021-10-08T00:14:21.463+00:00

i want to connect to teams online/sharepoint and get excel files via SSIS.

Microsoft Teams
Microsoft Teams
A Microsoft customizable chat-based workspace.
9,063 questions
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,798 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,617 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,452 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,245 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 32,736 Reputation points
    2021-10-08T05:28:06.88+00:00

    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

  2. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more