SQL Server Performance

OLEDB Not reading VFP datatype length correctly

Discussion in 'SQL Server 2005 Integration Services' started by JLDominguez, Jul 18, 2006.

  1. JLDominguez New Member

    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.

Share This Page