How to read a SharePoint list in SSIS

Objective

Because of the project needs, we will read some configuration data from SharePoint, and it is possible to perform some writeback operations to update the SharePoint data. No such operation has been done before, and some should be programmed to get or write some data through C #. Looking at some of the relevant articles, I also started to test how to access the SharePoint list in SSIS Package and write data to the SharePoint list.

Two actions

Reading data from a SharePoint List to a database

Filter some data from the database and insert it into a new SharePoint list

These operations do not involve any functionality that SharePoint can implement, simply demonstrating how to do it through SSIS, or whether the read-write logic is reasonable.

Step One – Install SharePoint List Source and destination

Because SSIS is a control that does not have a SharePoint operation, it is now available to the more-formed Third-party tools.

Go to CodePlex to download this control http://sqlsrvintegrationsrv.codeplex.com/releases/view/17652

My current test environment is VS 2008, I downloaded the first one and should be compatible to VS 2010. If it is version 2012, you should be able to use the second 2012 Beta version. Its installation and operation process is similar.

Install after download, then turn on VS 2008, and the interface will appear after the Data Flow Source toolbar or other tool bar in your project selects Choose items.

If it is vs 2010 or vs 2012, it may not be necessary for us to manually add these two controls, or even SSIS Data flow Items may not be found. It is quite possible that the two controls are automatically added to the Data Flow Toolbox while they are installed.

VS 2008 This is the choice, and then you can see the two controls in the Toolbox, one is source and one is target.

They will appear under general by default