Try using BulkInsert with TabLock ..but do note that TabLock will make the table unavailable for various operations by different users during the time of data population..