We can read data directly from Sharepoint List to SSIS using custom Transforms named SharePoint List Source and Destination. which can be download from codeplex site.
Download Link: Click Here
Example of reading data from sharepoint List
Step 1: Download and install SharePoint List Source and Destination transforms and add them to toolbox by using Choose items wizerd.
Step 2: Add Sharepoint Connection manager.
Download Link: Click Here
Example of reading data from sharepoint List
Step 1: Download and install SharePoint List Source and Destination transforms and add them to toolbox by using Choose items wizerd.
Step 2: Add Sharepoint Connection manager.
Step 3: Now, Drag and Drop Sharepoint List Source Source and configure it access your Sharepoint List as shown in screens below.
Please tell us how to get into "Add Sharepoint Connection manager Editor"
ReplyDeleteYou need to install Sharepoint List Source and Destination transforms from the link given in the begining of this post.
DeleteOnce you are done with installation, Right click on toolbox and check "Sharepoint List Source" And "Sharepoint List Destination" Transforms. So, that it starts appearing in toolbox.
Now, If you right clcik on Connection Manager window, "SPCRED" should start appearing in connection managers list.
Delete