I need to transfer data from MS SQL to MS Access which contains image data as one column.
I created one SSIS Package to export data from SQL to Access.THe export is success and the image data which is exported is appearing as Large Binary Object type in MS-ACCESS.When I try to open the image with double click, it is throwing error "close the ole server and restart it outside of microsoft access. Then try the original operation again in MS Access".
Please suggest me in this situation to proceed.
Thanks in Advance