Use the SharePoint list as the source and target in SSIS

When using the SharePoint list for data storage, data integration with other systems is really a big challenge. The first thing that comes to mind is to call the WebServices and Lists provided by SharePoint. the GetListItems method of asmx, but the encoding amount ...... I don't think there are too many people who like to write code. The most important thing is that when I want to call WebService components in SSIS, the WebServices provided by SharePoint actually report "A problem with the definition of WSDL ".

 

I had to find another method. Later I found a project on codeplex to solve this problem. Good things are not exclusive. We recommend them to you now.

 

The procedure is as follows:

1. Download the installation package from codeplex

Http://sqlsrvintegrationsrv.codeplex.com/releases/view/17652

SharePointListAdaptersSetup. msi is ForVS2008, and SharePointListAdaptersSetupForSqlServer2005.msi is For VS2005.

 

2. Close the running VS and run the installation file.

 

3. After installation, open the SSIS project in VS and add the two components to the toolbox.

* Switch VS off before installation !!!

The added results are as follows:

4. The last step is to use it. here we will not be so embarrassed. Just click a few points. For details, refer to the tutorial attached below.

1. The SharePoint list source has the following key attributes (Advanced editor ). If the view name is not written, the default view is used. In addition, you can remove unnecessary columns from the input/output attributes.

2. Several key attributes of the SharePoint list target, such.

 

With these two components, it is much easier to create a SharePoint dataset. I hope you can help.