I am using SqlBulkCopy to copy several tables to database. However, most of the tables are successfully copied to database except one table with 6000++ rows of data. When I run the function, it just simply hang there and not responding.
Below is my code:
using (SqlConnection destinationConnection = Login.GetConnection())
using (SqlTransaction transaction = destinationConnection.BeginTransaction(IsolationLevel.ReadCommited))
using (SqlBulkCopy bulkCopy = new SqlBulkCopy(destinationConnection, SqlBulkCopyOptions.KeepIdentity, transaction))
bulkCopy.DestinationTableName = "dbo." + tableName;
bulkCopySuccess = true;
catch (Exception ex)
bulkCopySuccess = false;
What is the possible problem? Is something wrong with my code?