SSIS SharePoint List Source "The HTTP request is unauthorized"

Nov 20, 2013 at 9:31 AM
Hello,

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?

Regards,
Ambra
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.

http://msdn.microsoft.com/en-us/library/lists(v=office.12).aspx

Any thoughts would be greatly appreciated.

Thanks!