Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SharePoint Online-Reading/Access Lists-Using SSIS -OData Connection- Error 401 Unauthorized

Status
Not open for further replies.

BTrees

IS-IT--Management
Aug 12, 2006
45
0
0
CA
Hi
I am trying to connect with Lists data on Sharepoint online. I am working in SSIS-Visual Studio 2017 and using Odata datasource connector.
I have installed SDK-2013 as well and followed all the instruction on blogs on this topic. But I am getting error , TITLE: OData Connection Manager Editor
Test connection failed. The remote server returned an error: (401) Unauthorized. (System)
I can access service document location and can see XML. Need help to get this working. Thanks


ODataConnection_y2dkdf.png





 
 https://files.engineering.com/getfile.aspx?folder=a02a4eae-7b0c-4560-abc4-e97189ef3d4b&file=ODataConnection.PNG
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top