> Hello,
>
> I have a DTS package that copies data from a sql server db to a visual
> fox pro file. The visual fox pro version we are using is very old
> (2.6a), and we actually use dbase 4
> drivers to copy data to it.
> In the create table statement in the dts package, we define decimal
> variables as being (6,4) long ie.. having at most 4 values after the
> period ex: 1.1111
>
> But when the data is copied, the decimal variables in the table are
> created as being (20,5).
>
> Why is this? is this some kind of default?
>
> Any help will be appreciated.
>
> Thanks,
>
> Burak
>

> Hi Allan,
>
> Yes, I am issuing a CREATE TABLE through DTS. I have to because if I
> don't drop and recreate the table, then the data in the sql server
> table just gets appended to the end of the dbf file, which results in
> duplicate data.
>
> I tried replacing the DROP TABLE command in the DTS package with
> TRUNCATE TABLE but it does not let me.
>
> And after dts creates the table, the decimal fields are all getting
> set to (20,5).
>
> Let me know if you have an ideas.
>
> Thanks,
>
> Burak
>