防止导入重复的行 [英] Preventing in importing duplicate rows

问题描述

亲爱的专家，

我正在做一个SSIS项目，负责每天将数据从源表导入目标表。但是当我第二次运行我的项目时，它会导入已经在第一次运行中插入的表的所有记录。如何防止插入重复行？

解决方案

我解决了自己。



我通过此链接解决我的问题，我解决了它。

http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/865eebb3-1bd6-432e-96ff-f8a747352e7a/ [ ^ ]

Dear Experts,
I am doing one SSIS project which is responsible for importing data from a source table to a destination table in daily basis. But when i am running my project 2nd time it imports all records of table which are already inserted in 1st time run. How to prevent inserting duplicate rows?

解决方案

I solved myself.

I gone through this link to solve my problem and i solved it.
http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/865eebb3-1bd6-432e-96ff-f8a747352e7a/[^]

这篇关于防止导入重复的行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！