• 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 record in a destination table, which is updated periodicaly.(without trigger ).

    Dima