Hello Friends, I have a problem in extracting data from share point server and load in the SQL tables. For this I do not have an option to install any additional components other than SQL Server. So I think the only way to extract data from a sharepoint server is by writing a script. Could someone help me in writing the script so as to connect to the Sharepoint server and extract data from there to a sql table. Thanks for your help in advance. Gupta. Suman Gupta

Try the links below : http://ask.sqlservercentral.com/questions/31534/loading-data-from-sharepoint-using-ssis http://www.pawlowski.cz/2011/04/reading-sharepoint-list-and-survey-data-using-integration-services-package/