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.

And i called that output variable in data transform Task.

I thought this might be helpful if someone read this post.

Thanks a lot everyone..