OLEDB Not reading VFP datatype length correctly | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

OLEDB Not reading VFP datatype length correctly

I’m importing data from VFP via OLEDB Provider in SSIS. However, the OLEDB Source task is not reading the correct length from the VFP table 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.
]]>