Venkat$ echo

This blog will cover the following items Read a SharePoint document Lists (in my case it is a document library and has custom columns)  And get a handle to each file available ( which can be used to import the data from the file) Use CAMLQuery specific files only. Update value back to Sharepoint file record.  the SSIS- sharepoint  adapater from CodePlex – ( SharePointListAdaptersSetup.msi ) - https://sqlsrvintegrationsrv.codeplex.com/releases/view/17652 Create a new SSIS Project and create a new “data flow Task” in “control Flow” screen a nd go to the “Data Flow” screen.   In “Data flow” screen you should see the below components. If not then something has gone wrong at step-1. Please fix that first. Also add the "SharePointList source" and SharePointList Destination" to the Data Flow Create a new "connection", by right clicking on "Connection Manager".  Select the Connection Manager for Sharepoint.  Now open the pro