Use the SharePoint list as the source and target in SSIS

Source: Internet
Author: User
Tags 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.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.