You have to uncheck Use fast load option for DTS package.

>Can you think of any reason that a DTS package would not work with this? It does work when entering the data by hand, but I have not been able to get it to work when using DTS to import a table set.
>
>
>>Try

>>UPDATE tProducts
>>    SET CurStockOnHand = CurStockOnHand + inserted.StockAdded - inserted.StockRemoved
>>  FROM tProducts
>>  JOIN inserted ON inserted.ProductID = tProducts.ProductID
>>

>>>I have the following code in a trigger which updates a filed in another table. I would like to be able to do bulk inserts without using a cursor, but am not sure how to do this in this case. Any and all help is very appriciated.