As the others have said, use the SQL tools for bulk loading, including the performance issues that you can control like the database logging. Use bulk load and set BATCHSIZE to the appropriate size based upon some testing by you.
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/incbulkload.mspx
Richard
There are three types of people in this world, those that can count and those that cannot. Anon