Only Inserting non existent in SSIS

I am newbie in SSIS. I need to insert Fact Table with only non existent data, and I found this post useful : http://jahaines.blogspot.com/2009/09/ssis-only-inserting-rows-that-do-not.html .

That post told how to do that using Lookup component, the key point is : When Non Matching entries found then redirect to Error Output, then Use the Error Output as Input for Destination component.

About these ads