NULL(DT_DATE Variable in SSIS

• mcfarlandparkway

  SSCertifiable

  Points: 7701

  More actions

  October 21, 2019 at 7:09 pm

  #3690722

  i have a variable in my SSIS package called

  Name                 datatype          value                       expression

  lastupdated      datetime          12/30/1899           NULL(DT_DATE)

   

  My package has logic based on this date.

  if @[User::lastupdated] == (DT_Date) "12/30/1899" it goes to leftflow

  if @[User::lastupdated] ! = (DT_Date) "12/30/1899" it goes to rightflow.

   

  i am using this same variable form my dtsconfig file and the value i kept as 2019-01-01.

  when i run the package as the value in this variable from config file is 2019-01-01, it should go to right flow. but it keeps on going to left flow.

  suppose if i remove NULL(DT_DATE) in the expression then it goes to right flow. not sure what is the issue here.

• Phil Parkin

  SSC Guru

  Points: 247155

  More actions

  October 21, 2019 at 7:40 pm

  #3690730

  Your expression NULL(DT_DATE) is returning the 1899 date always. You cannot change it, unless you change the expression to return something else.

  ---