Problem:
Package Processing hangs on forever, no error but keep processing
Reason:
Because insert, updates, or deletes work on the same table, resulting in heap contention, the table locked for the first action, so the subsequent actions hang on forever. The SQL codes in different tasks in in the package are treated as in a batch.
Solution:
1. Change the "BulkInsertTabLock" property for the destination table to False as shown below, you may also need to increase the timeout for a large data flow as shown below.
2. Create a cluster index or PK on the destination table
