显然有很多方法可以做到这一点，但这取决于几个因素(例如，您在进行传输时是否在 ServerB 中插入了更多记录??)

There are obviously many ways to do this, but it depends on a few factors (for instance, are you inserting more records into ServerB as you are doing the transfer?)

• 对 foreach 容器进行多播里面有一个 OLE DB 命令.称呼更新 ServerB 上的每条记录.
• 在您选择之前开始交易.选择完成后，将所有行更新为转移(如果您想要更多的原子性，请选择临时表以确保正确更新).完成后:提交.失败:回滚.
• 只需在完成时运行 SQL 命令:UPDATE ServerB.OrderRequest SET Transferred = 1 WHERE Transferred = 0