SSIS Sequence Container -transaction level

I have a sequence container and have defined DFD's inside the container.

From the source system,I am taking a dataset based on some criteria. . I need to find the maximum of an Id based on the result set.

For that I used Aggregate transformation editor and is taking lot of memory while getting the result(when processing tables with millions of data rows.)

My constraint is like ,I cant change the query(to select the max datetime from query itself).

Other soluton will be like using a execute SQL Task to get the latest datetime (within the DFD executable).

Will that cause data inconsistency problems(suppose a new row with max id gets inserte开发者_JS百科d when I use execute SQL task?).[Data mismatch between selected dataset max date and execute SQL maxdate?)

Or my understanding about the transaction level of Sequence Container is wrong?)

Use a SQL query to find the maximum - why use these tasks? Your problems though...maybe I don't want to understand ;)

My constraint is like ,I cant change the query(to select the max datetime from query itself).

Other soluton will be like using a execute SQL Task to get the latest datetime (within the DFD executable).

So you can't change your query, but you can create a new one? If you put those two tasks in a transaction container and set it correctly, transactions will take effect and stop an insert from happening until after you are done.