Hi all, i resoveld this issue..I did following steps

i wrote a select statement in my execute SQL task to select the max date

and assign that to output variable....