Hi Greg,

What's BCP?

Thank You



>Greg,
>
>I have code that does a weekly reload of a set of Sybase tables from VFP tables, it slogs around close to 1.2 gig of data. If the table has more than 1000 rows I use textmerge to create a text file to BCP into Sybase, it's a couple of orders of magnitude faster. BCP loads on the order of a few thousand rows per second. Creating the BCP file is on the order of hundreds of rows per second. So overall it's tons faster than doing INSERTS.
>
>>I find myself wondering how you loaded your initial data into SQL Server. Did you use BCP? If you used INSERT INTO, did you do anything special to write the INSERT INTO statement?