How to write Expression on Derived Column

• suresh0534

  SSCommitted

  Points: 1966

  More actions

  June 6, 2018 at 10:11 am

  #406589

  Hi,
  I importing File data using Flat File source with the Below Columns and I need to generate a new column with another File Name.

  

  I Need to generate a new File with the Below Out Put Like Below:
  
  

  Thanks

• Phil Parkin

  SSC Guru

  Points: 247159

  More actions

  June 6, 2018 at 10:23 am

  #1993112

  Use a Conditional SSIS Expression to do this.

  ---

• suresh0534

  SSCommitted

  Points: 1966

  More actions

  June 6, 2018 at 4:59 pm

  #1993159

  I tried below expression.

  But it's not working.

  While Importing data from Input file to the derived column , if input file contain any empty value it's not working.

  ISNULL([[Price] ]) ? [Salary] * [Percentage] / 100 : [[Salary] * [Price] / 100] 

  Thanks,

• Phil Parkin

  SSC Guru

  Points: 247159

  More actions

  June 7, 2018 at 5:21 am

  #1993188

  suresh0534 - Wednesday, June 6, 2018 4:59 PM

  I tried below expression.

  But it's not working.

  While Importing data from Input file to the derived column , if input file contain any empty value it's not working.

  ISNULL([[Price] ]) ? [Salary] * [Percentage] / 100 : [[Salary] * [Price] / 100] 

  Thanks,

  OK, try refining that as follows:

  ISNULL([[Price] ]) || [Price] == "" ? [Salary] * [Percentage] / 100 : [[Salary] * [Price] / 100] 

  ---