Can Sharepoint Online list be a SSIS data source?

Hi,

Is there a way to use Sharepoint Online list as SSIS data source / destination without buying any SSIS custom components?
lynqAsked:
Who is Participating?
 
lynqAuthor Commented:
2 Rainer

Any updates on modifying data source?
0
 
Rainer JeschorCommented:
Hi,
AFAIK it should be possible to use the SSIS SharePoint list adapters from codeplex
http://sqlsrvintegrationsrv.codeplex.com/releases/view/17652
which is free.

HTH
Rainer
0
Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

 
lynqAuthor Commented:
I was talking about Sharepoint Online as a part of Office 365 and not about on-premises version.
http://www.microsoft.com/en-us/office365/sharepoint-online.aspx
I used adapters from codeplex for on-premises version and it worked fine.
When I tried to use same adapters to connect to Sharepoint Online it didn't work.
I wonder if it's possible?
0
 
Rainer JeschorCommented:
Hi,
it seems that the Codeplex Connection Manager can not handle the custom login. I will have a look and perhaps I can modify the source to implement the custom login handling (which would also be necessary if you use claims / Forms Based Auth).
Please stay tuned.

KR
Rainer
0
 
lynqAuthor Commented:
It would be great.
0
 
lynqAuthor Commented:
Nobody helped
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.