Post reply

Capture non matching output from lookup task

  • January 29, 2016 at 8:39 am

    #399645

    Hi All,

    I have set up a data flow which checks values from an excel source against a sql server query using a lookup transform and outputs the results to a flat file (This works fine)

    I also want to capture the non-matching values from the excel source and put them in a separate flat file. This is the part i am having trouble with. When i attach the error output from the lookup to a flat file destination all it seems to pass through is null values and error codes.

    i have added some screenshots to illustrate my issue

    any ideas ?

  • March 8, 2016 at 7:41 pm

    #1863903

    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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply