Hi Dinesh Asanka!

Did you receive any other suggestions?

David gave very simple solution that works perfectly. Thank you!

Thanks to all for your suggestions!We found out that the problem was in application.

512MB RAM on the server. In Task manager SQLSERVER service is the biggest consumer.Only one specific client's application works on the server. There is a service,connected with this application, which corresponds to...

The suggestion of esmith21(the previous) works on my SQL Server, Thanks!!

Thanks a lot for your advice!

 My solution is the folowing:

I use Execute SQL Task from DTS and I execute Update statement against table. This way  I always have only one...

I'll check,but I have found a new solution of my problem without using  trigger.Thanks a lot!

I have created a local package (using SQL Server Enterprise Manager - DataTransformationServices).It contains two providers (a source and a destination ).They are linked with Transform Data Task.In Transform Data...