Read OLE Object Data from MS-Access which is imported from SQL Server

• pvsrpk

  SSChasing Mays

  Points: 602

  More actions

  June 15, 2010 at 3:24 am

  #387154

  Hi Friends,

  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

  Sriram