Configure Conditional Split Error Output

• Welsh Corgi

  SSC Guru

  Points: 116520

  More actions

  February 8, 2012 at 7:50 am

  #256384

  I have a conditional spilt task that moves records based on Department Code.

  This is a simplified Example:

  Order Output Name Condition

  1 HR Department == "HR"

  2 IT Department == "IT"

  3 IG Department == "IG"

  If I get a value that is not in the list specified, has a null value or empty string I want to direct the row to a Table Name ErrorOutput.

  When I try the following I get an error:

  Department == "HR" OR Department == "IT" OR Department == "IG"

  I would like to do NOT IN().

  What other steps do I need to do to redirects the bad rows?

  For better, quicker answers on T-SQL questions, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

• Phil Parkin

  SSC Guru

  Points: 247158

  More actions

  February 8, 2012 at 8:03 am

  #1444537

  The OR is the problem, I think. Try

  Department == "HR" || Department == "IT" || Department == "IG"

  ---

• Welsh Corgi

  SSC Guru

  Points: 116520

  More actions

  February 8, 2012 at 10:22 am

  #1444654

  Sorry I was not clear how about using NOT EQ.

  For better, quicker answers on T-SQL questions, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

• Phil Parkin

  SSC Guru

  Points: 247158

  More actions

  February 8, 2012 at 10:30 am

  #1444658

  !=

  ---