Two table Comparison to generate a Complete file and an Error file

[former_member591929]

I have an Output Table (Table 1) with 1.8M records. I have another table that has Cost Centers (CC Table). I need to compare Table 1 to CC table for Cost Centers (field) that don't exist in Table 1 then generate two tables: an Error Output table and an Output Table (Table 2). Table 1 is constructed by 32 source Excel and BODS files/tables combined with a Merge Transform. I'm not sure where to put the CC Table and how to connect it to perform the task. Any suggestions would be a lifesaver. Thank you.

[former_member187605 · Accepted solution]

Use a validation transform with an Exists in table Column validation. Connect the Fail output to the Error Table, the Pass output to the Output Table.

[former_member591929]

Worked like a charm. Thank you.