SSIS 2016 Reading Sharepoint 2013 Lists

Question

SSIS 2016 Reading Sharepoint 2013 Lists

Sam Garth 26 Microsoft Employee

Hi I am creating an SSIS package in VS2019 community edition using TargetServerVersion 2016 (if that matters).

I have an OData connection going to a 2013 version of SharePoint. This works successfully when connection.

I then use an Odata source and I get the error...

I have tried adding /_vti_bin/listdata.svc to the data source and it authenticates OK but still get the same error.

Can anyone point me to where I might be going wrong? I have installed the SharePoint Server 2013 Client Components SDK.

Thanks

1 answer

Your answer

Answer 1

Monalv-MSFT 5,926

Hi @Anonymous ,

Please check if the user has correct permission to the service location or if the service location in your OData Connection Manager is correct .

Hope the following links will be helpful:
1.OData Source
2.Tutorial: Using the OData Source

Best Regards,
Mona

----------

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues in November--What can I do if my transaction log is full?
Hot issues in November--How to convert Profiler trace into a SQL Server table?

Sam Garth 26 Reputation points Microsoft Employee

2020-11-24T16:21:54.82+00:00

Hi Mona

Thanks for your response, I am getting successful connections but I do not know what the URL should be. I do not know how SharePoint works I am afraid.

The URL to the correct list is...

http://sharepoint/sites/SITENAME/OTHERNAME/Lists/Client%20on%20Black%20List/AllItems.aspx

Is there a specific URL you would suggest I try?

I have tried

http://sharepoint/sites/SITENAME

http://sharepoint/sites/SITENAME/OTHERNAME

http://sharepoint/sites/SITENAME/OTHERNAME.svc

I then tried adding /vti_bin/...

It authenticates with all of these but I am guessing its not a valid URL maybe? Again I don't know how SharePoint works or is configured.

Thanks

Sam
Monalv-MSFT 5,926 Reputation points

2020-11-26T03:26:53.337+00:00

Hi @Anonymous ,

The OData source includes support for the following data sources:
1.Microsoft Dynamics AX Online and Microsoft Dynamics CRM Online
2.SharePoint lists. To see all the lists on a SharePoint server, use the following URL: https://<server>/_vti_bin/ListData.svc. For more information about SharePoint URL conventions, see SharePoint Foundation REST Interface.

Please refer to How to configure OData SSIS Connection for SharePoint Online.

Best Regards,
Mona

Share via

SSIS 2016 Reading Sharepoint 2013 Lists

1 answer

Your answer