SQL Batch Insert

Following snippet can be used to quickly upload ‘|’ separated record in SQL 2005 database table:

bulk insert cass.dbo.Stage1Input

FROM 'E:\tmp\cass\InputRecordDB.txt'

WITH

(

BATCHSIZE = 5000,

FIELDTERMINATOR ='|'

)

GO