SSIS 执行插入、更新和删除
我已经能够让我的 SSIS 流程使用排序、合并连接和条件拆分来处理插入和更新。
我不确定如何处理目标表上的删除，因为我的合并联接是来自源的左联接操作（因此我可以处理插入）。其他人是如何处理这种情况的？我尝试更改为完整外部联接，以便我可以在源中查找空值，但这似乎不起作用？
流（源：源和目标、排序：源和目标、合并连接、条件拆分：插入和更新）。
I have been able to get my SSIS process to handle the Insert and Updates using Sorts, Merge Join, and conditional split.
I am not sure how I could handle the delete on my destination table because my merge join is a left join operation off the source (So I can handle inserts). How have others handled this scnerio? I tried changing to a full outer join so I could look for a null in the source, but that didn't seem to work?
Flow (Sources: Source and Destination, Sorts: Source and Destination, Merge Join, Conditional Split: Insert and Update).
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
不确定这是否是您想要做的，但由于问题没有回复，我想我会提到
MERGE如果您运行的是 SQL Server 2008。您可以向 SSIS 添加一个 SQL 任务并编写代码查询根据需要处理插入、更新、删除或任何子集：这是 MS 文档：
http://technet.microsoft.com/en-us/library/bb510625.aspx
Not sure if this will be what you want to do, but since the question has no responses, thought I would mention
MERGEIf you are running SQL Server 2008. You could add a SQL Task to SSIS and code the query handle the inserts, updates, deletes, or any subset as needed:Here is the MS documentation:
http://technet.microsoft.com/en-us/library/bb510625.aspx