question

TomislavCrniloSMARTGROUPSERVICESdo-7376 avatar image
0 Votes"
TomislavCrniloSMARTGROUPSERVICESdo-7376 asked KranthiPakala-MSFT commented

SSIS/ADF - read excel file from Sharepoint/Teams

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

azure-data-factoryazure-sql-databasesql-server-integration-services
· 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.

@TomislavCrniloSMARTGROUPSERVICESdo-7376,
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.

0 Votes 0 ·

1 Answer

KranthiPakala-MSFT avatar image
0 Votes"
KranthiPakala-MSFT answered KranthiPakala-MSFT commented

Hi @TomislavCrniloSMARTGROUPSERVICESdo-7376,

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


· 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 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.

0 Votes 0 ·