THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Andy Leonard

Andy Leonard is an author and engineer who enjoys building and automating data integration solutions. Andy is co-host of the Data Driven podcast. Andy is no longer updating this blog. His current blog is

SSIS Snack: Configuring a Conditional Split

This blog has moved! You can find this content at the following new location:

Published Thursday, February 11, 2010 8:00 AM by andyleonard

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS



Lempster said:

Obviously the idea of this is to showcase the conditional Split transform, but another way of handling non-matching rows (new rows in the above example) is to configure the Error Output path of the Lookup transform.

By setting the Error disposition of the Lookup Output to 'Redirect Row', non-matching rows can be sent down a different data flow path.

February 18, 2010 4:05 AM

andyleonard said:

Hi Lempster,

  While technically correct, I find redirecting rows using an error path visually misleading. For this same reason, I do not recommend error precedence constraints in the Control Flow. Even if the error is managed properly in the context of SSIS, logs will reflect an error occurred. The convenient deflection against these arguments is "we should train everyone...". I diagree - people already get what an error is (they've already been trained). Why no leverage their existing knowledge in the context of SSIS, write a few more lines of code, and reduce the potential friction of misunderstanding?

Just a thought,


February 18, 2010 8:14 AM

Romualdo said:

hi! i like your alternative.

And if you want to use with New Rows (to blank tables). What to do?

July 20, 2011 1:14 PM

Martin Steel said:

Very helpful post

December 20, 2011 8:41 AM

Emil said:

I would like to add my comment on Lempster's comment because this approach doesnt work if there is no matching data. It will return an error and never will be forwarded. Therefore either error path or connecting destination with "non matching" option is the best way

December 16, 2014 6:38 AM

Leave a Comment


This Blog



My Latest Book:

Community Awards

Friend of Red Gate

Contact Me


Privacy Statement