Is there a limit on the size of the result set of an Execute SQL task. If yes, then how does one deal with the excess portion of result set ?
Why am I asking this ? I intend to get 4-5 GB sized record set into memory via Execute SQL task (PREFERRED), use it to generate sql statements. These sql statements will then be used to load data into my destination table.