Sunday, January 22, 2006

Oracle Driver and problems with Numbers...

Sorry for the long time not blogging, all....Holidays, vacations and know the drill...

Here's something from the "this ain't gonna work file"...

Do NOT use the ORACLE OLEDB driver for inserting data in an OLE DB destination! I have found that when you insert a number value that ends with a 0(zero) or a 5(five), that this value may be truncated or turned to zero. Definitely don't use it in a Lookup transformation either! I have seen it miss matches in keys that end in o(zero).

Double check your data and see if you are having this problem. Mine is against Oracle 10g on AIX 5.3.

80 degrees F here in Florida today!


Post a Comment

<< Home