question

ELIASNTOKOS-4906 avatar image
0 Votes"
ELIASNTOKOS-4906 asked JerryXu-MSFT commented

SSIS Sharepoint Online to SQL server

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-generaloffice-sharepoint-online
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Can you provide a better explanation of what end goal you're attempting to accomplish? There may be better alternatives.

0 Votes 0 ·
JerryXu-MSFT avatar image
0 Votes"
JerryXu-MSFT answered JerryXu-MSFT edited

Hi, @ELIASNTOKOS-4906,
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.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ELIASNTOKOS-4906 avatar image
0 Votes"
ELIASNTOKOS-4906 answered JerryXu-MSFT commented

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

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@ELIASNTOKOS-4906 , Per my knowledge, for SSIS, using MFA account will need to use App password for authentication. Here is an example for you to have a try: https://powerbinerd.wordpress.com/2019/06/13/ssis-odata-connection-with-sp-online-in-combination-with-mfa/

0 Votes 0 ·