BulkInsertorUpdateAsync would timeout 3 out of 5 times for very large set of data

[rdasgupta7141]

We are trying to upload large number of data from an excel sheet.<300k.
It works only 2 out of 3 times. It times out. I am guessing some timing out issue. Any ideas what might be up or if there is any setting in BulkConfig setting that we need to set values for. I set timeout =0 but still it does not help. I do see some deadlock in the sql profiler.

[borisdj]

You can test with different BulkConfig settings, specifically
BatchSize, BulkCopyTimeout, TrackingEntities, WithHoldlock;
SqlBulkCopyOptions Flags with one or more options:
Default, KeepIdentity, CheckConstraints, TableLock, KeepNulls, FireTriggers, UseInternalTransaction

Also here is more info on DeadLock #46