How to move IMAGES from oracle to MSSQL | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

How to move IMAGES from oracle to MSSQL

Hi,
How to move IMAGES from oracle to MSSQL 2000 SE,
I tried with linked server But I got the error, ok with normal data.
iam using MSDAORA for the linked server
INSERT INTO [IMG_table] SELECT * FROM ORALINKSERVER..GSC.[IMG_table] Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider ‘MSDAORA’ reported an error.
[OLE/DB provider returned message: Unspecified error]
[OLE/DB provider returned message: Oracle error occurred, but error message could not be retrieved from Oracle.]
[OLE/DB provider returned message: Data type is not supported.] –Srini
This may help u http://sql-server-performance.com/forum/topic.asp?ARCHIVE=true&TOPIC_ID=1639
]]>