更新时间:2023-12-04 17:58:58
嗨 neophytenik,
不幸的是,SSIS没有UPSERT目的地已经开箱即用。
Unfortunately, SSIS doesn't have UPSERT Destination out-of-the-box.
很久以前,一位微软实习生在SSIS开发。团队将其实施为 概念验证(POC),但它从未将其纳入实际产品。
Long time ago one Microsoft intern on the SSIS dev. team implemented it as a Proof of Concept (POC), but it never made it into the actual product.
这就是为什么***选择分为两步:
That's why the best option is a 2 step process: