Hi all, In my DTS, there is one task which involves a updating a large table from a smaller table. Currently this task is taking a very large time which is really a pain. So I am thinking of a way to splitting this task into two and then updating from these two tasks simultaneously. Hers's my approch....... I am updating column 'Lcol1' in table L from column 'Scol1' in table S. There is a join on Lcol2 and Scol2. 1. Move half data from table S to a temprary table(Task1) with same structure as S. 2. On completion of task 1 start two tasks. One will update table L from table S and other from temporary table. 3. truncate the temprary table. I am specifying WITH (NOLOCK) in both the parallel update task. Need inputs whether this would be feasible or a UPDLOCK will prevent the other query from running and the second query will have to wait. Also any other alternative suggetion is welcome.