Loading

Load data to a SQL table from sharepoint list

Jhonny Banegas

6y913SQL

Hello,

I want to Create a SSIS package that loads data to a SQL server table from a sharepoint list, similar to what Madhan comment in this post https://www.c-sharpcorner.com/article/ssis-write-custom-message-or-variable-value-in-ssis-log-file/

Nowaday, this task has been impossible to performed, any guide to follow will help a lot.

Thanks

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Abhijeet Jadhav6y ago
Hi Jhonny,
Solution to your question is dependent on multiple factors:
1) Volume of Data
2) Frequency of schedule
3) Available tools and current licenses owned by your org

You can consider "Azure Data Factory" Solution if it is suitable considering above factors :

https://azure.microsoft.com/en-us/pricing/details/data-factory/ssis/
Rajanikant Hawaldar6y ago
Are you looking for this, correct me I am wrong. https://www.itprotoday.com/sql-server/integrating-sharepoint-data-sql-server