Connecting or Integrating with SharePoint in a SSIS package using OData

Поділитися
Вставка
  • Опубліковано 1 гру 2024

КОМЕНТАРІ • 22

  • @MamathaD-v8n
    @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

  • @renukasingh9576
    @renukasingh9576 4 роки тому

    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.

  • @lucyfoley1370
    @lucyfoley1370 2 роки тому

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

  • @MrJohn2475
    @MrJohn2475 3 роки тому +2

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

  • @leamiscool
    @leamiscool 4 роки тому +1

    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

  • @nelsonma4711
    @nelsonma4711 4 роки тому

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

  • @SK-ck3qb
    @SK-ck3qb 5 років тому +1

    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!

  • @guggilamdivyasai3451
    @guggilamdivyasai3451 6 місяців тому

    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
      @mohamedhusain7807 6 місяців тому

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

  • @ponrajm5173
    @ponrajm5173 6 років тому

    Very Useful

  • @DakaraiManyati
    @DakaraiManyati 2 роки тому

    THanks!

  • @satheeswariv3827
    @satheeswariv3827 4 роки тому +1

    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?

  • @uchechiibekwe2407
    @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
    @JP-td8gt 2 роки тому

    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
    @JP-td8gt 2 роки тому

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