SharePoint list as OData Source forbidden error

Senior Member

I want to connect to SharePoint list as OData source in SSIS, But it always occurs an error and the error message as the following:

 

===================================

Test connection failed

===================================

The remote server returned an error: (403) Forbidden. (Microsoft.SqlServer.IntegrationServices.ODataConnectionManager)

------------------------------
Program Location:

at Microsoft.SqlServer.IntegrationServices.OData.ShimSharePointOnlineCredentials.GetAuthenticationCookie(Uri uri)
at Microsoft.SqlServer.IntegrationServices.OData.UI.ODataConnectionManagerForm.GetWebRequest()
at Microsoft.SqlServer.IntegrationServices.OData.UI.ODataConnectionManagerForm.TestConnectionMiddle(Object callback)

 

0 Replies