dateadd is not valiadting is SSIS derived column

• Prashant-402994

  SSC Journeyman

  Points: 87

  More actions

  October 21, 2007 at 11:49 pm

  #183091

  Hi, I am using following expression in SSIS

  DATEADD( "hour" , TT_DETL_TO_TM_ZN_OFST , TT_DETL_POD_DTT)

  and here the number field and the date fields are columns coming from source

  any idea is I am missing something.

  Thanks in advance.

• Dr. John Tunnicliffe

  Right there with Babe

  Points: 782

  More actions

  November 19, 2007 at 3:05 pm

  #752464

  Try this instead. It works for me.

  DATEADD( "hh" , TT_DETL_TO_TM_ZN_OFST , TT_DETL_POD_DTT)