• Your images aren't showing up so I can't see your exhibits, but from what you described, I suspect you need to use the No Match Output (not the Error Output) from the lookup transformation. Just make sure that you configure the lookup transformation to redirect unmatched rows to the No Match Output, on the bottom of the first tab of the lookup transformation configuration.

    Hope this helps...

    Tim Mitchell, Microsoft Data Platform MVP
    Data Warehouse and ETL Consultant
    TimMitchell.net | @Tim_Mitchell | Tyleris.com
    ETL Best Practices