Please help. OData connection load data from Office 365 to sql server. How i can load data from sql server to office 365 list with ssis?

2 Answers 2


I suppose you could create a C# custom code activity in the SSIS package that uses Client Side Object Model (CSOM) to upload data to a list in SharePoint Online. It invovles quite a bit of coding though. I do not know if there is an easier/faster way to do this.


Have you tried the SQL Integration service component available at Codeplex.

This sample demonstrates how to get data into and out of SharePoint lists by using custom source and destination adapters written in C# 3.0. Use this sample to learn more about:

SharePoint List Source and Destination

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.