Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Execute SQL Task - Any limit on the size of result set Expand / Collapse
Posted Friday, November 1, 2013 3:04 PM


Group: General Forum Members
Last Login: Thursday, May 15, 2014 8:51 PM
Points: 183, Visits: 480
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.
Post #1510820
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse