Using SSIS to download Shared Excel doc from Sharepoint

• rjdineen

  Mr or Mrs. 500

  Points: 515

  More actions

  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

  

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

  

  Can someone point me in the right direction please.

  Kind Regards

  Rob

• Phil Parkin

  SSC Guru

  Points: 247158

  More actions

  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.

  ---