incase if you haven't figured it yet, this can be done efficiently with an execute sql task.

select "result set" as "single row",

write your sql statement like "select max(id) as id...