I have made DTS package for data migration. On Error i like to update the table. other wise the status will be changed success. But when the sql fails the query is not getting excuted. When i checked in the profiler the Event has the following


"SQL:BatchCompleted" "UPDATE RegLogContact_mst SET intDeleteFlag=3 where strCompanyName = 'SHINDO TEXTILE CO.,LTD.xxx' and strCreatedBy='Tess SH Moon'"; Microsoft® Windows® Operating System sa 0 77 0 60 936 54 2004-02-04 11:07:34.930


But the next sql is excuted. Please help me out in this.