A Truncation occurred during the evaluation of the expression.

• rupesh.gajjela

  SSC Veteran

  Points: 255

  More actions

  April 22, 2015 at 9:18 am

  #303209

  Below is my exp. I'm migration SSIS 2005 packages to 2012. It works fine when i run in 2005 but in 2012 it gives an error about truncate ? I'm not sure about this

  Can someone please help...

  (((DT_DATE)@ArchiveStartTime < (DT_DATE)@ArchiveEndTime) ? ((getdate() < (DT_DATE)((DT_WSTR,12)(DT_DATE)(DT_DBDATE)getdate() + " " + @ArchiveEndTime)) && ((DT_DBTIME)getdate() > (DT_DBTIME)@ArchiveStartTime)) : ((getdate() < (DT_DATE)((DT_WSTR,12)(DT_DATE)(DT_DBDATE)getdate() + " " + @ArchiveEndTime)) || ((DT_DBTIME)getdate() > (DT_DBTIME)@ArchiveStartTime))) && (@ChangeLogsRemoved > 0)

  User variables:

  ArchiveEndTime Sting 14:56

  ArchiveStartTime Sting 11:00

  Thanks!!

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  April 22, 2015 at 10:25 am

  #1792816

  Duplicate post. Replies here please: http://www.sqlservercentral.com/Forums/FindPost1679290.aspx

  -- Gianluca Sartori