data type and/or operator symbol problem

• kewing

  Grasshopper

  Points: 12

  More actions

  January 8, 2008 at 9:10 am

  #182420

  I am trying to use an equation which includes exponential notation (^) in a Derived Column Task in SSIS. I am getting and error that says "Data type DT_NUMERIC can not be used with binary operator "^". " The data type of the column being referenced (BP_mbar) is FLOAT (DT_R4). Am I representing the exponential notation symbol incorrectly? I tried a search in the helpfiles and nothing relevant comes up.

  The equation in question is

  Round((([BP_mbar] - 0.3) * ((1 + ((((1013.25 ^ 0.190284) * 0.0065) / 288) * (41.5 / ([BP_mbar] - 0.3) ^ 0.190284))) ^ (1 / 0.190284))) * 0.02953, 4)

  (This works in MS Access 2000.)

  THANKS!!!

• kewing

  Grasshopper

  Points: 12

  More actions

  January 8, 2008 at 1:03 pm

  #765886

  OK, I'm missing most of what was left of my hair, but I GOT IT!!!!

  I needed to use the function "POWER" with two parameters.

  YIPES!!!

  :w00t: