Type cast error in Email task

• anthu_soft

  SSC Enthusiast

  Points: 196

  More actions

  November 22, 2009 at 11:29 pm

  #385833

  Hi,

  I have an email task transformation in my package. in email task i have written the following expression

  "Successfully ran " + @[System::PackageName] + " on " + @[System::MachineName] + " - " + " at StartTime " + (DT_STR, 32, 1252) @[System::StartTime] + " with current getdate " + (DT_STR, 32, 1252) (DT_DBTIME) getdate()

  when i evaluate the expression i am getting error.

  if i changed the DT_DBTIME to DT_DBDATE, it works fine. but i need only the time.

  the expression is correct?

  Thanks in advance

  Anthuvan