Best Practice is to perform the udpate using stored procedures and call them within the DTS workflow, that will save lot of server resources as and when that update query runs from DTS the optimizer will nto be able to use best plan to execute for optimum performance. Also do not use office automation...