Hi I want to automate the process to moving images from SharePoint Library (or anywhere) to SQL Server... I used a SSIS package to move SharePoint List data to SQL server but I don't know how to go about moving the attachment image with the list... I could use Document or anything else within SharePoint instead of attachment but how can I move it SQL Server... Any ideas would be appreciated... Thanks

Ashish , 1. You are moving them out of Sharepoint to SQL to store space ? 2. Are these very very big files ? - If answer to 1&2 is Yes "Remote BLOB storage" is your answer I am assuming you are using SP2010 ? Thanks Sandeep Nahta AppliedIS Hyderabad Sandeep Nahta http://snahta.blogspot.com

Ashish , 1. You are moving them out of Sharepoint to SQL to store space ? 2. Are these very very big files ? - If answer to 1&2 is Yes "Remote BLOB storage" is your answer I am assuming you are using SP2010 ? Thanks Sandeep Nahta AppliedIS Hyderabad Sandeep Nahta http://snahta.blogspot.com

Hi, According to your description, I have found a good SQL Server Integration Service (SSIS) File Operations – Copy File, Move File, Remove File and Delete File. You could create a package which loads data in to SQL Server table from a flat file. For more information, please refer to: http://beyondrelational.com/blogs/ashish/archive/2010/08/31/ssis-file-operations-copy-file-move-file-rename-file-and-delete-file.aspx http://jtlovessharepoint.blogspot.com/2010/06/moving-list-with-large-attachments.html Best Regards David Hu