>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

Just reread this...and you should be able to go directly to the target DB without upsizing. DTS will allow you to redirect to differently-named fields, no worries there.

Do you have any active indexes on the target table? Those would definitely cause a performance problem. Best to drop all indexes not directly needed by the import, then rebuild afterwards. You can do this with SQL tasks before and after the transfer within a DTS package pretty easily. Triggers can also get in the way.

DTS bypasses the log so you shouldn't have a performance issue there.

Hope that helps.