Derived Column Help

• rocky_498

  SSCertifiable

  Points: 6532

  More actions

  February 14, 2011 at 7:24 pm

  #144713

  Hi guys,

  I am working on SSIS Project, I have three situations where i need your help. I know i can accoplish in DERIVED COLUMN TRANSFORMATION, but i am not very good in expressions.

  1) IF SOURCE.EXTRA4 <=1 THEN TARGET_DUE = SOURCE.EXTRA3 OTHERWISE TARGET_DUE = 0

  2) IF SOURCE.EXTRA3 IS NUMERIC THEN TARGET_CHARGED = SOURCE.EXTRA3

  3) I HAVE TWO COLUMN PAYMENT AND PAID, I WANT TO BRING THOSE VALUE WHO EVERY IS GREATER. HOW I CAN DO THIS THING IN SSIS.

  I realy appreciate for your help.

• Koen Verbeeck

  SSC Guru

  Points: 259105

  More actions

  February 15, 2011 at 2:05 am

  #1286908

  1. The syntax is as follows: (boolean_expression) ? expression_if_true : expression_if_false

  2. There is no IsNumeric function in the derived column, but you can build it with a script component:

  http://consultingblogs.emc.com/jamiethomson/archive/2007/05/03/SSIS_3A00_-Checking-for-IsNumeric_28002900_.aspx

  3. What do you mean with "I want to bring this value"? Do you want to store the highest value in a column? If yes:

  (Payment > Paid) ? Payment : Paid

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP