Share via

The remote server returned an error 403 forbidden using oData source to read from SharePoint 2019 List on-premise

Shahid K 11 Reputation points
2022-02-16T09:42:52.387+00:00

I have migrated SSIS packages from SQL Server 2012 to 2019 but once I open them in Visual Studio 2019 I could not get the SharePoint List source component working.

Online article suggests that I should use oData source. This package reads SharePoint 2019 lists and dumps data into SQL server.

I tried configuring oData but being first timer. I do not know the correct config. SharePoint Server 2019, Visual Studio 2019, SQL server 2019

Basically, I need to replace SharePoint list source component with similar component to make the packages work again. How I configure oData in SSIS to read from SharePoint 2019 on-premise?

174834-pic1.png

174835-pic2.png

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,462 questions
SharePoint Server Development
SharePoint Server Development
SharePoint Server: A family of Microsoft on-premises document management and storage systems.Development: The process of researching, productizing, and refining new or existing technologies.
1,576 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 33,386 Reputation points
    2022-02-17T02:43:29.08+00:00

    Hi @Shahid K ,

    When you configure the OData Connection Manager, have you try to click connect to see if it could success?

    175211-image.png

    Here are some tutorials you may take a reference to.

    tutorial-using-the-odata-source

    how-to-configure-odata-ssis-connection-for-sharepoint-online

    Details about odata-source, you may also see the documentation.

    Regards，

    Zoe

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    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.