SSIS : How to access SharePoint site and load data from SharePoint using SSIS to SQL database ?

kkran 831 Reputation points
2023-04-11T22:08:00.88+00:00

Hi All - I am looking for help. I have an requirement of pulling the data from Sharepoint site into SQL database using SSIS.

What could be the pre-requisites to build the SSIS package ?

  1. Do i need the sharepoint site username and password ?
  2. Should i install any third part plug in ?
  3. Any other details needed ?

Thanks

SharePoint Server
SharePoint Server
A family of Microsoft on-premises document management and storage systems.
2,283 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,183 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,130 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,502 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. AllenXu-MSFT 17,666 Reputation points Microsoft Vendor
    2023-04-12T06:45:04.74+00:00

    Hi @kkran,

    To load data from SharePoint using SSIS to SQL database, please see this detailed tutorial:

    Yes, you need the SharePoint site username and password to fetch data in SharePoint list.

    If the answer is helpful, 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.

    1 person found this answer helpful.