SSIS/ADF - read excel file from Sharepoint/Teams

Question

SSIS/ADF - read excel file from Sharepoint/Teams

Tomislav Crnilo (SMART GROUP SERVICES d.o.o.) 1

Hi,

I would like to know is it possible to read excel file stored on Sharepoint ( not sharepoint list, excel file is stored on sharepoint and integrated with MS Teams) in SSIS or ADF to Azure SQL Server? Our sharepoint is synced with my local machine and I use Excel connector is SSIS and that works if I run package locally ( because file location is C:\User...\file.xlsx).
But when we try to run it through SSIS in Azure Data Factory it fails due to credentials ( we need to have this option to have job scheduler).

Thank you,
BR Tom

Sharon Zhao-MSFT 25,756 Reputation points Microsoft External Staff

2021-10-28T06:11:38.937+00:00

@Tomislav Crnilo (SMART GROUP SERVICES d.o.o.) ,
According to your description, your question is more related to the SQL and ADF. As we are mainly responsible for general question of Microsoft Teams, we don’t find much useful solutions for this thread from Microsoft Teams side. Someone checking other tags will give you more insights. Thanks for your understanding.

1 answer

Your answer

Sharon Zhao-MSFT 25,756 Reputation points Microsoft External Staff

2021-10-28T06:11:38.937+00:00

@Tomislav Crnilo (SMART GROUP SERVICES d.o.o.) ,
According to your description, your question is more related to the SQL and ADF. As we are mainly responsible for general question of Microsoft Teams, we don’t find much useful solutions for this thread from Microsoft Teams side. Someone checking other tags will give you more insights. Thanks for your understanding.

Answer 1

KranthiPakala-MSFT 46,642 Microsoft Employee Moderator

Hi @Tomislav Crnilo (SMART GROUP SERVICES d.o.o.) ,

Welcome to Microsoft Q&A forum and thanks for reaching out here.

Are you trying read Excel files from Sharepoint Online using ADF? If that is the case you can refer to this article which has a demonstration on how to achieve it using ADF: How to read files on SharePoint Online using Azure Data Factory

Here is related MS Doc: Copy file from SharePoint Online using ADF

Hope this helps. Please do let us know how it goes.

Thank you

KranthiPakala-MSFT 46,642 Reputation points Microsoft Employee Moderator

2021-11-04T19:19:12.72+00:00

Hi there,

We still have not heard back from you. Just wanted to check if the below information was helpful? If it answers your query, please do click “Accept Answer” and/or Up-Vote, as it might be beneficial to other community members reading this thread. And, if you have any further query do let us know.

Share via

SSIS/ADF - read excel file from Sharepoint/Teams

1 answer

Your answer