title: How can multiple Stored Procedures update same row at same time?
body: <p>I am using SSIS 2008 to execute multiple stored procedures in parallel in control flow.
  Each SP is supposed to ultimately update 1 row in a table.</p>
  
  <p>The point to note is that each SP has a defined responsibility to update specific columns only.</p>
  
  <p>It is guaranteed that the different SPs will not update each other's columns. So the columns to be updated are divided between the various SPs, but as per design, each SP is supposed to work on the same row ultimately.</p>
  
  <p>At the moment some of my SPs error out due to deadlock. I am guessing this may be because of the lock on that row by other SPs?</p>
  
  <p>How can i work this out?</p>