>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 ) ?
Pete,
Probably DTS would do it quite well (I don't know, didn't work with it much). One of the options I like and works better than linked server is OpenRowSet().
Cetin