SSIS Expression

• vijaygodishala69

  SSC Rookie

  Points: 49

  More actions

  March 18, 2015 at 1:03 am

  #398202

  Hi,

  I have two columns. address 1 and address2. if address1 is null then show address2. if address1 and address2 both are not null then show only address1. how to do in SSIS Expression.

  Please help.

• Koen Verbeeck

  SSC Guru

  Points: 259085

  More actions

  March 18, 2015 at 1:55 am

  #1784666

  If you have SQL 2012 or up:

  REPLACENULL(address1,address2)

  If not:

  (ISNULL(address1)) ? address2 : address1

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