Share via

OData source to sharepoint error

rajanisqldev-42 221 Reputation points
2023-07-04T11:57:54.5766667+00:00

Dear,

I am trying to retrieve data from sharepoint lists using OData source in SSIS.

I am getting error when I test connection.

I am able to access in the browser.

What is the issue?

odata error.png

Microsoft 365 and Office | SharePoint | For business | Windows
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Ling Zhou_MSFT 23,690 Reputation points Microsoft External Staff
    2023-07-05T01:41:59.9633333+00:00

    Hi @rajanisqldev-42,

    Thanks for your detailed case description. I completely understand the situation and your feelings.

    However, I find that your problem is more related to SQL Server Integration Services. In this forum we discuss more about SharePoint and have limited resources for SQL Server Integration Services.

    Therefore, I suggest you post your concern in this SQL Server Community to get the detailed help from the experts.

    Thank you for your kind understanding!

    If the answer is helpful, 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.

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.