Differenct between Lookup Error Output and Lookup No Match Output RRS feed

  • Question

  • Hi All

    I'm new in SSIS and reading book for SSIS and unable to understand the difference between Lookup Error Output and Lookup No Match Output in Lookup transformation. Are these terms same or is there any difference between them ?. Please guide




    Monday, March 24, 2014 7:45 AM


  • Nope. Error output is more generic ie any errors happening inside lookup can be redirected to error output by default. This includes lookup match failures as well as data conversion error, truncation error etc. Upto SSIS 2005 this was the only output available in addition to match output inside lookup so if you want to capture unmatched rows you had to redirect them to error output itself.

    But from SSIS 2008 onwards they've introduced one more output called no match output. This gives you ability to redirect only no matched rows through no match output so that you'll be able to distinguish between unmatched rows and other error rows.

    You can configure this option inside Specify how to handle rows with no matching entries option in Lookup Editor. You can choose Ignore Failure, Redirect rows to no match output,Redirect rows to error output etc as options

    Please Mark This As Answer if it helps to solve the issue Visakh ---------------------------- http://visakhm.blogspot.com/ https://www.facebook.com/VmBlogs

    • Proposed as answer by SSISJoostMVP Monday, March 24, 2014 9:49 AM
    • Marked as answer by muzokh Monday, March 24, 2014 4:27 PM
    Monday, March 24, 2014 9:01 AM