SSIS : How to connect to SharePoint and load data from SP to SQL table

TH Liu 40 Reputation points
2023-11-30T08:42:28.9566667+00:00

As titled, i could not find the source editor in SSIS

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,704 questions
0 comments No comments
{count} votes

Accepted answer
  1. ZoeHui-MSFT 41,491 Reputation points
    2023-11-30T08:52:38.1766667+00:00

    Hi @TH Liu
    You may consider using OData source in SSIS.

    Check: How to configure OData SSIS Connection for SharePoint Online

    You may follow the blog step by steps.

    Regards,

    Zoe Hui


    If the answer is helpful, please click "Accept Answer" and upvote it.

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.