Saturday, March 19, 2011

SharePoint List and SSIS SQL Server

Requirement:

Loading and Extracting data from SharePoint List and SQL Server SSIS packages.

  1. The first and the foremost thing required is to download the .msi from codeplex called SharePoint List Source and Destination Sample to add the components to the SSIS Tool box.
  2. Click the CodePlex Link: http://sqlsrvintegrationsrv.codeplex.com/
  3. Click Download
  4. Once the download is completed:
  5. Open BIDS
  6. Go to the Data Flow of any package
  7. Open Toolbox (If Toolbox is not open Go to VIEW at the top and from the drop down select Toolbox)
  8. Right click on DATA FLOW SOURCES -> CHOOSE ITEMS -> Click on SSIS Data Flow Items -> Scroll down and Select  SHAREPOINT LIST SOURCE -> Click OK
  9. Now you will be able to see the SHAREPOINT LIST SOURCE on DATA FLOW SOURCES
  10. Perform steps 7-9 for DATA FLOW DESTINATION
  11. Added Screen shots for Clarity


No comments:

Post a Comment