SSIS Derived column question

• slimchance99

  SSCrazy

  Points: 2661

  More actions

  November 14, 2006 at 2:11 pm

  #153295

  Having just started poking around SSIS I am trying to add derived columns to a query result in data flow but all of the date functions that use the 'datepart' parameter always show as an error and will not evaluate. The error is always something like:

  'attempt to find the input column named 'dd' failed with error code....The input column specified was not found in the input column collection'

  This is the error for an expression like DATEDIFF( dd, [First Contact] ,  [referral_date]  )

  I must be missing something basic but I cannot find what it could possible be.

  Thanks

  Tim

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  November 14, 2006 at 2:18 pm

  #671774

  Looking at BOL, you need to but the dd in double quotes: "dd"