HI I tried with Snapshot. It still raising DEADLOCK issue. and some records are not getting updated properly. Please suggest:

1. Isolation Level

2. Locks for DELETE statments

This is reference to this Question :

The Sequence Container contains three Execute SQL Tasks (Execute SQL Task 1, Execute SQL Task 2, and Execute SQL Task 3) connected by OnSuccess...