大家好,
我每天都会将增量数据加载到Staging表中。
I have incremental data loaded into the Staging table on a daily basis.
目前,我使用登台数据使用SQL(执行SQL任务和数据流)在目标表上执行插入/更新/删除
Currently, i use the staging data to perform insert/update/delete on the destination table using SQL(Execute SQL task and data flow)
但是我想将进程移动到SSIS,以便能够根据登台数据插入/更新目标表,而不必使用eexcute sql任务插入/更新,
but i want to move the process to SSIS, to be able to insert/update the destination table based on the staging data wihout having to use eexcute sql task for insert/update,
请指导有助于实现结果的现有SSIS任务,非常感谢
Please guide on existing SSIS tasks that help to achieve the outcome, thanks very much
推荐答案
嗨 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 aProof of Concept (POC), but it never made it into the actual product.
这就是为什么最佳选择分为两步:
That's why the best option is a 2 step process:
更多推荐
基于临时数据删除/插入/更新的SSIS包
发布评论