Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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
Author
Message
Posted Friday, November 01, 2013 3:04 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, April 15, 2014 2:32 PM
Points: 182, Visits: 479
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