>Hi All, I've imported a lot of Fox dbf (2.6 for Dos ) tables into SQL Server 2005, what I would like to do,is, import only data that has changed since the last run , e.g I ran the import for the first time today and would like to run it every day to look for changes. I don't know if this is possible , or maybe there's another *better* way - any ideas ?
Sounds like you need to create a SSIS package for the task.
If it's not broken, fix it until it is.
My Blog