Streejith,

Here is the stored procedure.  It is pretty straightforward.  I am going to try using profiler to see if there any lock...

SET XACT_ABORT ON

SET NOCOUNT ON

BEGIN TRANSACTION

UPDATE MYTABLE SET TRNSTAT='Y'

WHERE MY

Yes, that worked. 

Thank you very much for your help...

Raj

Unfortunately, the double quotes are coming from the flat file.  There are certain columns (character fields) that are coming across from the mainframe with those double quotes.  So when DTS...