OLE DB Source not reading correct datatype length -
07-18-2006
, 01:53 PM
I'm importing data from VFP via OLEDB Provider. However, the source is not
reading the correct length from the source and subsquently the task fails due
to truncation. For example the source datatype of NUMERIC(7,3) is picked up
as NUMERIC(6,3) by the OLE DB Source task. In addition, It only does this on
some numerics columns not all-in the same table. I've installed the latest
OLEDB Provider which I believe is 9 and it is still occuring?? Thanks in
advance. |