SqlBulkCopy Tutorial - Knowledge Base (KB)

SqlBulkCopy.WriteToServer not reliably obeying BulkCopyTimeout

I need to count sequential timeout exceptions from SqlBulkCopy. To test this, I use an external app to start a transaction & lock up the target table. ...Only on the first call does SqlBulkCopy throw a timeout exception when expected. We've tried using an...

Timeout Expired using SqlBulkCopy when there are 300Million rows in SQL Server Database

I wasn't having any problems in inserting ~15000 rows in SQL Server database when using SQLBulkCopy in certain conditions where there are 183M existing rows in the database....But when there were 300M existing rows in the database, i experienced the excep...