The error message was 'Unspecified Error'. I don't know if it just 'timed out' or ran out of memory.

It is a relatively simple data transfer - there are just a couple of extra fields in the new table and one field has a different name. I was able to upsize the table from VFP to a new SQL Database I created. I then tried DTS from between the 2 SQL databases. Ran through all the 7.1Million records then hung up for about an hour. Had to cancel so we could do something else on the server. Is there an easy way to transfer without logging each record? Maybe that would work quicker...I don't need to log the data import at this point. We are only trying to test the data.

Thanks,
Doug