Post reply

Using SSIS to download Shared Excel doc from Sharepoint

  • July 1, 2020 at 10:37 am

    #3766646

    I want to download excel file that has been shared with me on Sharepoint.

    So i used an OData Source, which i enter my shared URL into the service document location with my credentials, and i get a

    'Test Connection Succeeded'  GREAT. see image

    OData Connection success

    When i try to configure an Odata source and use the Odata connection, with Use collection or resource path as 'Resource Path' i get...

    OData Source Error

    Can someone point me in the right direction please.

    Kind Regards

    Rob

  • July 1, 2020 at 12:51 pm

    #3766686

    I have not tried doing this, but as far as I can see, the OData connection gives you access to the data in SharePoint lists, not to the data stored in files which have been loaded into SharePoint.

    Take a look at this thread and see whether it helps.

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply