OData Error: The remote server returned an error: (403) Forbidden. (System)

Question

Hi everyone,

I am trying to create an SSIS package that pull data from a SharePoint list and when I tried to use OData Data Source Component in SSIS I got this error:

**TITLE: OData Connection Manager Editor

Test connection failed

ADDITIONAL INFORMATION:

The remote server returned an error: (403) Forbidden. (System)

BUTTONS:
OK
------------------------------**

Please can someone advise me on what I am missing and if there is an alternative way to get the data apart from using OData.

PS: This happens when I use both Windows Authentication, Basic Authentication and Microsoft Online Services.

Answer 1

Hi @tobz ,

May I know what's the version of your Visual Studio?

You may have a try to see if “Microsoft Online Services Authentication” has been set to true.

Details you may refer: using-the-odata-source-connector-with-sharepoint-online-authentication

Also please have a check if you could connect to the SharePoint list via browser.

Regards，

Zoe

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

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.