Hi All I have a Column of Record_End_Dt which is already date is their. i have to update that value to yesterdays date. Can i do it using conditional split something like (Record_End_Dt==Getdate()-1) i used like this in my conditional split, but its throwing error, can anyone please helpit out.. its urgent. if possible can please reply with correct syntax Thanks ========= Supreeth

You need a Derived Column Transformation...Configure the derived column transformation to repace Record_End_Dt and set the following expression DATEADD("d",-1,getdate()) http://btsbee.wordpress.com/

Hi Supreeth, sathyas

Hi Supreeth, sathyas