>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.
Dan LeClair
www.cyberwombat.comSET RANT ON - The Wombat BlogLife isn’t a morality contest and purity makes a poor shield. - J. Peter MulhernDisclaimer: The comments made here are only my OPINIONS on various aspects of VFP, SQL Server, VS.NET, systems development, or life in general, and my OPINIONS should not be construed to be the authoritative word on any subject. No warranties or degrees of veracity are expressed or implied. Void where prohibited. Side effects may included dizziness, spontaneous combustion, or unexplainable cravings for dark beer. Wash with like colors only, serve immediately for best flavor.