I have the following code..which actually inserts data into destination using SQLBulkCopy. This code is failing in source SQL server frequently because of deadlock. FYI the table that is being copied can be in use (I meant some inserts/selects would be ru...