>Ok,
>
>I go through and set up a DTS to move an existing VFP table to an existing SQL 7 table.
>
>All SEEMS to work well with set-up - that is - all fields etc show up from both tables and I map like I think it should be. There are some new fields in the SQL table, and some no-longer used ones in VFP. Some fields have changed names. Nevertheless, I am meticulous about mapping them properly - specifying "" whenever there is a field that exists in one table but not the other.
>
>All goes well until I push "finish" at the end. - at which point the DTS dialog "lock-up" on me and I haveto force quit out of Enterprise Manager. I have reinstalled the latest MDAC (though I seem to now have dual copies of some of the files).
>
>Any ideas anyone?
>
>thanks,
>Ken
I don't think a SQL table can hold "" like VFP can. You have to set the columns to Allow Null, and instead of using "" tell it to use Null.
Bob
PS: Not sure if this is your problem... you should get an error message about column can't be empty.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement