Better approach to find a data from ADO.NET source in DFT in SSIS 2008

I have a DFT and I have defined a ADO.NET Source and an ADO.NET Destination. I need to find the maximum of a datetime column from ADO.NET source.

Currently I am using aggregate transformation which has two outputs one with maxdatetime and the other one with all columns in group by to get all t开发者_StackOverflowhe rows in the other output. MaxDatetime -Maximum Date time from column AllRows -All rows(defining all columns in the group by )

Is there any better way to do this.

I dont want a group by for the ADO.NET source as its a slow operation.

Can't you just use an execute SQL task, Select Max(datetimeColumn) from tablename and store the result in a variable.

I have done similar follow up on the MS forum and got this answer. Hope I can post the link here. http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/8d02957e-becb-440a-9eba-9540b620b617