SSIS Test Project First Phase Tested and Working...

Alas, it is only a simple but nice example of it working. The complete SSIS package will require quite a few of these, plus more complex flows:

Picture of Example Flow
	Above shows the simple flow in 3 stages.   1 - Get the Data   2 - Perform Lookup to see if row specific columns exist   3 - Write rows that failed (didn't exist in new table) to the new table.
	The red line shows the path for failed result (no row found in lookup).

However, according to the Online Help of SSIS (see here) i found this snippet that you must set the Error Output Event: You can do this by selecting one of the following options:   > Ignore the failure and direct the rows to an output - Direct the rows anyway to the actual output (the Green line).   > Redirect the rows to an error output - Redirect the Source Rows of data to the Error Output (the Red line).   > Fail the component - Fail the component if any error happens.