Connecting from SSIS to SharePoint Lists - any Chance?

Question

Connecting from SSIS to SharePoint Lists - any Chance?

MrAkki

SSCrazy

Points: 2574
More actions
March 6, 2007 at 7:07 am

#116007

Hi,
I was wondering if there is any way to connect directly to some sharepoint list from SSIS or BI or SQL-Server Management Studio?
Thanks,
Thorsten

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

S. Kusen SSChampion Points: 10936 More actions · Answer 1

I would suggest taking a look at SQL Server 2005 SP2 as it should have more integration with SharePoint. See this article:

http://blogs.msdn.com/sharepoint/archive/2007/02/19/microsoft-sql-server-2005-sp2-reporting-services-integration-with-wss-3-0-and-moss-2007.aspx

Dave Bach SSC Rookie Points: 35 More actions · Answer 2

At this time there is no simple provider for Sharepoint 2003 lists. I have not tried any Sharepoint 2007 lists as of this post.

If you want to use reporting services, use Access 2003/2007 and link to the desired lists. Use mdb in reporting services. Not what we want to use, but it works.

dinogas2000-sqlservercentral SSC Enthusiast Points: 104 More actions · Answer 3

There is now:

http://www.codeplex.com/SQLSrvIntegrationSrv

Supports some cool features:

- Removing columns from the data flow connection will cause the load query to be more optimized

- Paging large list sets is supported automatically

- Supports modifying and deleting rows

- Can provide CAML for Where clause filtering

COZYROC One Orange Chip Points: 28499 More actions · Answer 4

If you can use third-party solutions, check the commercial CozyRoc SharePoint integration. These are the relevant components:

* SharePoint Source SSIS Data Flow Component

* SharePoint Destination SSIS Data Flow Component

* SharePoint SSIS Connection Manager

Batch insert and update is also supported.

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/