?
Solved

Can Sharepoint Online list be a SSIS data source?

Posted on 2012-08-28
7
Medium Priority
?
1,648 Views
Last Modified: 2013-02-23
Hi,

Is there a way to use Sharepoint Online list as SSIS data source / destination without buying any SSIS custom components?
0
Comment
Question by:lynq
  • 4
  • 2
7 Comments
 
LVL 44

Expert Comment

by:Rainer Jeschor
ID: 38340021
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
 
LVL 17

Expert Comment

by:Barry Cunney
ID: 38340097
0
 

Author Comment

by:lynq
ID: 38340371
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
Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

 
LVL 44

Expert Comment

by:Rainer Jeschor
ID: 38341081
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
 

Author Comment

by:lynq
ID: 38341110
It would be great.
0
 

Accepted Solution

by:
lynq earned 0 total points
ID: 38601761
2 Rainer

Any updates on modifying data source?
0
 

Author Closing Comment

by:lynq
ID: 38920820
Nobody helped
0

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
This shares a stored procedure to retrieve permissions for a given user on the current database or across all databases on a server.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Suggested Courses

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question