I have been following the example in this site:


And everything works just fine if SP is inhouse but when I try to connect to the SharePoint Online (office 365) it's not able to make the connection on step #9.

I get the following message:

"Error at Data Flow Task [SharePoint List Source [1]]; System.ServiceModel.Security.MessageSecurityException: The HTTP request was forbidden with client authenigcation schema 'Ntlm'...."

This is clearly due to authentication.

What is credentials format? I tried <domain>\<user> and <email>, but nothing seems to work. I don't think Ntlm would be supported for SP online but I may be wrong.

So is this even possible? Or is there another option to get this data using SSIS?

Thank you for reading.

  • are you able to create a back-up of the SP database locally and SSIS from there? I seem to remember SSIS not being supported but I can't find any documentation Apr 3, 2013 at 17:18
  • I guess that could be an option, but sharePoint backup is also not very trivial, and all I want is a couple fields out of a list, taking a backup and then reading from it seems a little too much work.
    – MicroSumol
    Apr 3, 2013 at 19:57

2 Answers 2


NTLM is not supported for SharePoint online. You have to use the OData API which requires OAuth authentication. Out of the box, SSIS will not support this and you will have to write CLR code if you are going to try.


yeah, i have been doing this...

i use

  • a claims class for authentication
  • a custom SSIS script task, with parameters for username, password etc.
  • connect to an oData feed (either json or atom)
  • i then use CSOM to populate termstores or SharePoint lists

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.