i have a as400 at main office and i need information to be entered here at my office with sql server 2000. i have the dts set up, i hope correctly, the problem is i can’t update. the information is correct, yet when i ask for update\changed information i get a violation error about duplicate rows.