Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Read OLE Object Data from MS-Access which is imported from SQL Server Expand / Collapse
Author
Message
Posted Tuesday, June 15, 2010 3:24 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, July 17, 2014 4:39 AM
Points: 29, Visits: 253
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
Post #937337
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse