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!!