ssis expression on dt_dbtimestamp

• wm_wbt

  SSC Veteran

  Points: 267

  More actions

  April 23, 2020 at 4:45 pm

  #3745735

  I'm working on a package using a conditional split where I need to work against updating rows and the following is erroring out:

  ((ISNULL(UTCDateTime) ? "" : UTCDateTime) != (ISNULL(LkUp_UTCDateTime) ? "" : LkUp_UTCDateTime))

  --

  Error at Data Flow Task 1 [Conditional Split [163]]: The data types "DT_WSTR" and "DT_DBTIMESTAMP" are incompatible for the conditional operator. The operand types cannot be implicitly cast into compatible types for the conditional operation. To perform this operation, one or both operands need to be explicitly cast with a cast operator.

  Error at Data Flow Task 1 [Conditional Split [163]]: Attempt to set the result type of conditional operation "ISNULL(UTCDateTime) ? "" : UTCDateTime" failed with error code 0xC004709F.

  --

  How do I add a cast in the expression for the field: UTCDateTime

  • This topic was modified 4 years, 7 months ago by  wm_wbt. Reason: moved to different forum section

• Site Owners

  SSC Guru

  Points: 80330

  More actions

  April 24, 2020 at 5:10 pm

  #3746123

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.