>Hi there, I need to update some fields in a SQL table from a Fox dbf two or three times daily , I currently do this using a linked server and SQL agent but it's proving to be very unreliable - SQL reports that an ODBC error has occurred - low on memory etc etc... and only restarting SQL server will fix it, sometimes it runs for a week without a problem other times only for a day, is there any way to use DTS to perform an update ( I know you can insert and copy ) ?
Oh, and there is also an incredibly good tool called FullConvert that will let you map VFP tables to SQL Server and send data over very successfully. Very handy, very configurable and understands a lot of the idiosyncracies of VFP.
Charles Hankey
Though a good deal is too strange to be believed, nothing is too strange to have happened.
- Thomas Hardy
Half the harm that is done in this world is due to people who want to feel important. They don't mean to do harm-- but the harm does not interest them. Or they do not see it, or they justify it because they are absorbed in the endless struggle to think well of themselves.
-- T. S. Eliot
Democracy is two wolves and a sheep voting on what to have for lunch.
Liberty is a well-armed sheep contesting the vote.
- Ben Franklin
Pardon him, Theodotus. He is a barbarian, and thinks that the customs of his tribe and island are the laws of nature.
