Connecting or Integrating with SharePoint in a SSIS package using OData

[@MrJohn2475]

Can OData connect to an excel file in a sharepoint folder?

[@chenchugurram6728]

I have same query ? Did you got answer ?

[@MamathaD-v8n]

I am getting the successful OData connection manager but unable to view the collection inside the ODataSource editor Could you please suggest on these

[@ponrajm5173]

Very Useful

[@lucyfoley1370]

Any idea why i can't see the Microsoft Online Services Authentication property in my properties window?

[@DakaraiManyati]

THanks!

[@renukasingh9576]

Please tell me which version of visual studio you are using, I am using visual 2013 and unable to establish connection getting error as unexpected underlying error.

[@leamiscool]

Is there a way to use SharePoint as the destination rather than the source? I would like to send files from our local network to a SharePoint source if possible. Thanks

[@adolfogorjon9989]

you did?

[@SK-ck3qb]

Can u make a video showing how to use a SharePoint Destination? I can only find paid options for connectors. I am using Visual Studio 2017. Thanks!

[@behindtheline40]

Did you find any answers to this?

[@nelsonma4711]

Hi there, can you also get data from Project Online?

[@guggilamdivyasai3451]

Hi 1.I tried the same way using Microsoft Online Service Authentication but I am getting "the remote server returned an error Unauthorized" For which URL I am able to get data through browser. 2.Also received the error: IDCRL did not get response from the login server. 3. With Basic authentication: Forbidden error and I don't find the Microsoft service authencation to set it to true Any idea?

[@mohamedhusain7807]

Hi, Has the issue been resolved? I'm currently experiencing a similar problem. Could you please assist me?

[@satheeswariv3827]

Hi while connecting i am getting error Test connection failed -> 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...could you please help me on that?

[@kailashrawal1569]

Same error I got

[@himakishore7066]

Found any solution? Do we want to get installed Sharepoint client components ?

[@priyadarshini8863]

@@himakishore7066 Yes!

[@robertoherrera6462]

@@priyadarshini8863 Hi, what was the solution?

[@uchechiibekwe2407]

Please can you guide me on how to solve the problem of this error and what it means... It keeps popping up when I click the "test connection" ........................................... TITLE: OData Connection Manager Editor Test connection failed ADDITIONAL INFORMATION: The underlying connection was closed: An unexpected error occurred on a send. (System) Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host. (System) An existing connection was forcibly closed by the remote host (System) BUTTONS: OK

[@JP-td8gt]

The problem with OData Source is that it will not return/display a MultiValue Field from share point within SSIS environment. Which is horrible product experience.

[@JP-td8gt]

Biggest downside is Odata will not return sharepoint column that is of multi choice type