SSIS Sharepoint Online to SQL server

ELIAS NTOKOS 21 Reputation points
2020-09-08T10:07:20.933+00:00

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

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,677 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,598 questions
Accepted answer
  1. Jerry Xu-MSFT 7,921 Reputation points
    2020-09-09T02:42:28.843+00:00

    Hi, @ELIAS NTOKOS ,
    More detailed information about your setup and goal will help us to provide more specific suggestions. And only for the error message, have a check on the Assembly and try to close & reopen the VS to set up the connection again. Make sure you have installed the SharePoint Online components SDK.

    Reference:https://social.msdn.microsoft.com/Forums/vstudio/en-US/557cd871-b93f-4e55-8e75-a5d7b1a65adf/getting-error-when-try-to-connect-to-sharepoint-on-cloud-from-ssis-vs?forum=sqlintegrationservices

    Similar thread: https://social.technet.microsoft.com/Forums/azure/en-US/facddeb9-422a-4f05-8690-fe87bb4724bd/ssis-package-to-connect-to-sharepoint-online-via-odata-connector?forum=sqlintegrationservices

    If the answer is helpful, please click Accept Answer and upvote it.
    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.

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. ELIAS NTOKOS 21 Reputation points
    2020-09-09T11:23:20.753+00:00

    Hi Jerry,

    Thank you for your quick response, Finally the issue was happened because the account I used is MFA enabled so I used another one without MFA and works.
    However is there any way to create connection using O365 Modern Authentication in order to use MFA accounts?
    Thanks in advance

    ELiasHi Jerry,

    Thank you for your quick response, Finally the issue was happened because the account I used is MFA enabled so I used another one without MFA and works.
    However is there any way to create connection using O365 Modern Authentication in order to use MFA accounts?
    Thanks in advance

    ELias

  2. Qaiser 0 Reputation points
    2023-12-11T23:16:12.46+00:00

    Version 16 of SharePoint Client Library will not work as error is looking for Versions 15.

    Install version 15 on both SSIS server and Client side and authenticate using Office 365 username and password rather than Cookie which seems to be an obsolete method to authenticate. Still needs confirmation from Microsoft it they have made obsolete Cookie method.

    https://www.microsoft.com/en-us/download/details.aspx?id=35585

    This should have fixed the problem as I have fixed mine.

    0 comments