question

Nitesh-5533 avatar image
0 Votes"
Nitesh-5533 asked ZoeHui-MSFT edited

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

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

office-sharepoint-onlineoffice-teams-windows-itprosql-server-reporting-servicessql-server-integration-servicessql-server-analysis-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ZoeHui-MSFT avatar image
0 Votes"
ZoeHui-MSFT answered ZoeHui-MSFT edited

Hi @Nitesh-5533,

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


· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @Nitesh-5533,
Do you have further question on this , could we offer more support?
If this helps on your issue, you could mark it as answer so other user with similar problem could see this easier. :)

0 Votes 0 ·
COZYROC avatar image
0 Votes"
COZYROC Suspended answered

I would recommend you check the commercial COZYROC Microsoft Graph connector. You can use it download files from SharePoint Online.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.