October 5, 2005 at 5:11 am
Hi Gurus
I am trying to run a query in DTS(SQL2000) to oracle server, If I select a BLOB column I get an unknown error in DTS.
But if other columns are selected except th BLOB data type column, it works OK.
Any ideas.
regards Vicky
October 5, 2005 at 9:02 am
BLOB data stands from Binary Large Objects and may not be something you want to dts.
If it is, then this might help:
http://support.microsoft.com/default.aspx?scid=kb;en-us;257425&sd=tech
October 5, 2005 at 9:08 am
The Blob Datatype cant be imported in DTS
This is what is found in MSDN
The Microsoft ODBC and OLEDB drivers for Oracle support the Oracle 7.3 BLOB data types, not Oracle 8.0 data types. For example, BLOB, CLOB, NCLOB, and BFILE are not supported.
October 6, 2005 at 5:44 pm
I am using a DTS package to copy blobs out of Oracle into a sql200 table so that I can export them to .jpg. I found that you have to have the blob as the last object to be exported or it won't work....
SELECT ID, LENGTH, TYPE, DATE_INSERTED, PICTURE
FROM
QLQLS.PICTURES
WHERE (DATE_INSERTED > SYSDATE - 5)
The SQL Picture is of type image and the Oracle Long Raw...
I hope this helps.
Michael
October 8, 2005 at 12:35 am
Thanks all,
I tried Rookie's method selecting column in the end of the query, no luck.
I will try out Addict's suggestion sometime today as our internet is down for 2 days.
I am bit worried by Grasshopper's post, if it is still true i mean if this problem has not been solved in any of the service packs then I am concern.
once again thanks a lot.
Regards Vikram.
October 8, 2005 at 1:02 am
Hi Vikram,
Download the oracle migration work bench and it will do it for u.
It is free in download option of Oracle.com(omwb.zip)
Blob datatype field is stored by default in system tablespace and u must have defined the user on diffrent tablespace.
Hope this help
from
Killer
October 8, 2005 at 1:56 am
Hi,
Go through this link it will definately help u
http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/sqlorcle.mspx
Hi Suresh,
U can easily tranfer the datatype to Oracle (BLOB,CLOB, Image) from ODBC connection string.
from
Killer
October 12, 2005 at 4:47 am
Hi Killer,
migration work bench may not be solution for me as I aill be running DTS everyday as schedule job.
But the link you have posted looks promising, I will walk through it.
Thank with appreciation.
regards Vikram
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply