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

Question

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

Answer 1

Hi @kkran,

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

• Load Data to an SQL Table from a SharePoint List Using SSIS - Part One
• Load Data to an SQL Table from a SharePoint List Using SSIS - Part two
• Load Data to an SQL Table from a SharePoint List Using SSIS - Part three

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.