Monday, January 23, 2006

Driver Sources for Oracle

Here is my preliminary list of what works against Oracle....

OLE DB Source - use the Oracle Driver, but be cautious of Numerics and use a data viewer to make sure that numbers to the right of the decimal come through...

Lookup - Use the Microsoft Driver...using the Oracle driver will cause mismatches of all records when comparing numbers, like when looking up keys.

SCD - Oracle OLE DB other choice, because the Microsoft driver can't handle parameters

OLE DB command - Same as above, as you need parameters

OLE DB Destination - use the Microsoft driver, as numbers ending in 0 (zero) will be turned into zeroes!!!


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!