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 ]; 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
<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.