Hi All, We have two sharePoint lists in moss 2007 and want to extract the data in SQL Server 2008. Please keep in mind we have a one master list and using another list column as lookup field. I need the list data information along with the lookup field column. I was thinking to query the SharePoint content db directly but not sure if this is a right approach? Please let me know. Thanks, Gaurav http://gauravsqlserver.blogspot.com

this link completely explained how you can extract data from sharepoint list with SSIS: http://msdn.microsoft.com/en-us/library/dd365137%28v=sql.100%29.aspx you can also use lookup or merge join transform to merge two lists if you like.http://www.rad.pasfu.com

I used this utility and is working fine.Thanks, Gaurav http://gauravsqlserver.blogspot.com