I have a couple of tables that I'm importing from Oracle into SQL 2005 and
I'm importing them into one table. Unfortunately I'm finding out that the
tables have duplicate data. After importing the first table from oracle, is
there a way of check the "new" SQL table for existing records and if the
record exists to "move" the dup record to a new table for spot checking.

Thanks in advance

Use a Lookup Transform.

Set the Error Output on the component to be "Redirect Row".

Now all matches (i.e. things you already have in the reference table) will
go down the green path and new rows will go down the red (error path)

http://wiki.sqlis.com/default.aspx/S...rorOutput.html

--


Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com


"scuba79" <scuba79 (AT) discussions (DOT) microsoft.com> wrote