dateadd expression is ssis is not validating

• Prashant-402994

  Valued Member

  Points: 57

  More actions

  October 21, 2007 at 11:52 pm

  #183066

  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:11 pm

  #752469

  Try

  DATEADD( "hh" , TT_DETL_TO_TM_ZN_OFST , TT_DETL_POD_DTT)

• foxjazzG

  SSCrazy

  Points: 2221

  More actions

  September 25, 2013 at 8:36 am

  #1653200

  this doesn't work in SSIS 🙁

  DATEADD( "hh", [TimeZone] ,[DockDepartureTime] )