Hello,
I am trying to do an insert from one db table to another. It works great
until a record that is a dup of one that is already in the destination table.
(Which I do not want inserted) I do not want the package to fail just not
insert the dup record.

Thank You
For any Help
Greg

insert into TableA
select * from TableB where not exists (select *from tableA where id
=TableB.id)



“I sense many useless updates in you... Useless updates lead to
defragmentation... Defragmentation leads to downtime...Downtime leads to
suffering..Defragmentation is the path to the darkside.. DBCC INDEXDEFRAG and
DBCC DBREINDEX are the force...May the force be with you" --
http://sqlservercode.blogspot.com/


"gaiams via SQLMonster.com" wrote: