Requirement:
Loading and Extracting data from SharePoint List and SQL Server SSIS packages.
- 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.
- Click the CodePlex Link: http://sqlsrvintegrationsrv.codeplex.com/
- Click Download
- Once the download is completed:
- Open BIDS
- Go to the Data Flow of any package
- Open Toolbox (If Toolbox is not open Go to VIEW at the top and from the drop down select Toolbox)
- Right click on DATA FLOW SOURCES -> CHOOSE ITEMS -> Click on SSIS Data Flow Items -> Scroll down and Select SHAREPOINT LIST SOURCE -> Click OK
- Now you will be able to see the SHAREPOINT LIST SOURCE on DATA FLOW SOURCES
- Perform steps 7-9 for DATA FLOW DESTINATION
- Added Screen shots for Clarity
No comments:
Post a Comment