SSIS SharePoint List Source "The HTTP request is unauthorized"

Nov 20, 2013 at 9:31 AM

I'm using a SSIS SharePoint List Source component in order to connect to a SharePoint portal and to read data from lists: when I configure the component in design mode, I'm able to connect and see the structure (that is the list of columns) of the lists, but when i run the package in debig mode I get the following error "Error: System.ServiceModel.Security.MessageSecurityException: The HTTP request is unauthorized with client authentication scheme 'Ntlm'. The authentication header received from the server was 'NTLM'"

I'm accessing SharePoint via HTTPS.

What is the problem? Is there a workaround to solve it?

Nov 22, 2013 at 6:56 PM
I am also getting the same error message. It's due to the type of authentication used on the site, ADFS. I am able to connect just fine to site without ADFS.

I've been told a possible solution using the List Web Serivce but I have not used Web Service before.

Any thoughts would be greatly appreciated.