sql server dts: SQL float truncation when exporting via DBASE in DTS -- sql server dts

SQL float truncation when exporting via DBASE in DTS

ezelasky NO[at]SPAM hotmail.com
9/29/2004 10:58:48 AM

sql server dts: When I export a SQL table with a field that is defined as float(8)
using a dBase5 driver the digits after 5th digit to the right of the
decimal are dropped. Why is this happening? It doesn't happen when I
export to a FoxPro database. Would it be the dBase driver driver? If
so which driver should be used?

I saved the DTS package as VB code and messed around with the
destination column data types, which I found defined in oledb.h file,
but the truncation still exists.

Re: SQL float truncation when exporting via DBASE in DTS

Allan Mitchell
9/29/2004 8:12:26 PM

It would sound like a dBase driver issue. You could do a search for another
driver on the internet or lookup the docs and see if this is as expected.
Short of that you may want to ask in a dBase NG from people wh are Gurus
with dBase.

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.Konesans.com

[quoted text, click to view]