http://www.windowsitpro.com/authors/author/author/5338207/rsscomment/5338207en-USSun, 27 May 2012 06:15:39 GMTSun, 27 May 2012 06:15:39 GMThttp://www.windowsitpro.com/article/sql-server-2005/integrating-sharepoint-data-with-sql-server-#commentsAnchorSat, 18 Sep 2010 11:12:55 GMT
It is truely disappointing that when I click on the List 1 link to the required code, it takes me to the beginning of the article...I’ve learned my lesson...I won’t shop for information on this site again.]]>MamaSat, 18 Sep 2010 11:12:55 GMThttp://www.windowsitpro.com/article/sql-server-2005/integrating-sharepoint-data-with-sql-server-#commentsAnchorhttp://www.windowsitpro.com/article/sql-server-2005/integrating-sharepoint-data-with-sql-server-#commentsAnchorTue, 08 Jun 2010 16:59:58 GMT
If you can use third-party solutions, check the commercial CozyRoc SharePoint integration. These are the relevant components:

* SharePoint Source SSIS Data Flow Component http://www.cozyroc.com/ssis/sharepoint-source
* SharePoint Destination SSIS Data Flow Component http://www.cozyroc.com/ssis/sharepoint-destination
* SharePoint SSIS Connection Manager http://www.cozyroc.com/ssis/sharepoint-connection

Batch insert and update is also supported.]]>PeevTue, 08 Jun 2010 16:59:58 GMThttp://www.windowsitpro.com/article/sql-server-2005/integrating-sharepoint-data-with-sql-server-#commentsAnchorhttp://www.windowsitpro.com/article/sql-server-2005/integrating-sharepoint-data-with-sql-server-#commentsAnchorTue, 22 Sep 2009 15:50:39 GMT
Is this SSIS package accessing the SharePoint list via wcf webservice? We are using Microsoft online to host are SharePoint environment. For data access they say no access to data via SSIS. But we can access via WCF/Web Service Interface. Please advise]]>rodneyTue, 22 Sep 2009 15:50:39 GMThttp://www.windowsitpro.com/article/sql-server-2005/integrating-sharepoint-data-with-sql-server-#commentsAnchorhttp://www.windowsitpro.com/article/sql-server-2005/integrating-sharepoint-data-with-sql-server-#commentsAnchorSun, 03 May 2009 11:39:38 GMT
Another approach that’s quite a bit easier as well as more robust is my company’s open source project SLAM. SLAM, SharePoint List Assocation Manager (http://slam.codeplex.com), allows you push list data to SQL as well but it sychronizes the data in real time (not batch) and additionally allows you to model complex joins (one to one, one to many, many to many). We have a brief intro video here: http://www.awsystems.com/slam. Yours, Allan]]>AllanSun, 03 May 2009 11:39:38 GMThttp://www.windowsitpro.com/article/sql-server-2005/integrating-sharepoint-data-with-sql-server-#commentsAnchorhttp://www.windowsitpro.com/article/windows-sharepoint-services-30/customize-search-features-in-microsoft-office-sharepoint-server-2007#commentsAnchorWed, 02 Jul 2008 09:36:21 GMT
efsaefee]]>blarg1234 Wed, 02 Jul 2008 09:36:21 GMThttp://www.windowsitpro.com/article/windows-sharepoint-services-30/customize-search-features-in-microsoft-office-sharepoint-server-2007#commentsAnchor