SSIS-how to assign Null Value to Integer/Numeric Datatype Column/Variable

• deeep

  SSC Eights!

  Points: 950

  More actions

  December 17, 2008 at 3:50 am

  #197603

  hi all

  i am using a condition in Dervie Column ,, my Derive Column is "Int/Numeric"

  if my condition Ture then i am performing some calculation otherwise NULL value shoule be assigned to Column value.

  i have tried to passs the null value through a uservariable also.

  uservariable1 (type-Int/Numeric) value- System.DBNull.Value

  uservariable2 (type-Int/Numeric) value- System.int32.Null

  Please provide the solution ASAP.

  its very urgent..

  Thanks in advance.

• Jack Corbett

  SSC Guru

  Points: 184388

  More actions

  December 17, 2008 at 8:04 am

  #913849

  Your derived column should do something like this:

  x==True ? x + y : Null(DT_I8)

  You need to choose the correct data type in the Null, but that is the basic idea.

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question