I would use SSIS (SQL2005) or DTS (SQL2000) to do this in SQL Server. You could also use the BCP in SQL if it's a one time deal. I pass a LOT of data into and out of SQL Server via text files and it runs very fast. In fact we have one process where we have to move a Fox (DOS) free table close to 2GB into SQL every week. The fastest way I found to do it was to write a little Fox app that simply opened the table and did a COPY TO ... command to create a text file. Then, I bring that text file into SQL using DTS and a bulk insert object.

HTH,
Chad


>Hi!
>I wrote a program in Visual FoxPro(VFP). This prgram fetches data from text file named 'capture.txt) one by one) ,parseed record to fields, converts fields to different data types and append this data in DBF table. It processes more than 70,000 records within 34 seconds.
>
>Same code I written in SQL server T-Sql. It processed the same data within 5 Minutes. How can I boost up the speed of this process. (Note: The T-SQL procedure; I executed it from VFP. VFP fetches records(one by one) from the Capture.txt file and sends it to T-SQL Procedure in form of a parameter, rest of processing is done on SQL Server.)
>Same procedure like VFP's ; from Visual Basic to SQL-Server took near about 9 minutes.
>How can I boostup this data processing in SQL-Server so that data processing should be speedy.(near Visual FoxPro's speed minimum.)
>Note: In SQL-SERVER I used TRUNCATE technique also, it reduced the processing time 5-10 seconds.
>Note:In SQL-SERVER I left the step of (VFP)REQUERY(). REQUERY() Fetches fresh data from SQL-SERVER Table TO VFP table still.