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
ADDITIONAL INFORMATION:
Could not load file or assembly 'Microsoft.SharePoint.Client.Runtime, Version=15.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c' or one of its dependencies. The system cannot find the file specified. (mscorlib)
BUTTONS:
OK
Can you please advise ?
Thank you
Elias