Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I have been following the example in this site:

http://blog.nhaslam.com/2012/01/26/loading-reference-data-from-a-sharepoint-list-using-ssis/

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.

share|improve this question
    
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 –  Ryan Erickson Apr 3 '13 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 '13 at 19:57
add comment

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.

share|improve this answer
add comment

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
share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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