Connecting or Integrating with SharePoint in a SSIS package using OData

This video will demonstrate how to connect or integrate SharePoint in SSIS package using OData.

[renukasingh]

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.

[MamathaD-vn]

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

[MrJohn]

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

[SK-ckqb]

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!

[nelsonma]

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

[lucyfoley]

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

[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

[satheeswariv]

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, or one of its dependencies. The system cannot find the file specified...could you please help me on that?

[guggilamdivyasai]

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?

[JP-tdgt]

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

[uchechiibekwe]

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-tdgt]

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.