conditional split

• Mvs2k11

  Ten Centuries

  Points: 1223

  More actions

  June 26, 2012 at 10:23 am

  #150989

  I am new to SSIS and have a conditional split issue.I want to insert to rows when the below conditions.

  SUBSTRING(status,1,1) == "A" && (Transfer==0)

  Please correct above if i missing anything.

  Thanks for you help in advance..

• Rock from VbCity

  Hall of Fame

  Points: 3991

  More actions

  June 26, 2012 at 11:50 pm

  #1505975

  Hi MVS2k11

  Your condition looks good to me, please follow these steps to add a conditional split to your solution:

  1. Add the Conditional Split transform to your solution, and connect it to the precedent component.

  2. Double click on the Conditional Split in order to open its editor.

  3. Enter you condition as shown

  4. Assign a name to your condition, any name would do.

  Once you close the Conditional Split transform, the condition you entered become available as an output of the control.

  You can enter as many conditions as required, each one will yield an output.

  

  Cheers,

  Hope this helps,
  Rock from VbCity