My goal is to Integrate Sharepoint Online to SQL server 2014, However when I try to create a SSIS Odata connection to MS online account in order to connect to SP online list. I got the folllowing error.
TITLE: OData Connection Manager Editor
Test connection failed
Could not load file or assembly 'Microsoft.SharePoint.Client.Runtime, Version=126.96.36.199, Culture=neutral, PublicKeyToken=71e9bce111e9429c' or one of its dependencies. The system cannot find the file specified. (mscorlib)
Can you please advise ?