Page 1 of 1

big rowset

Posted: Tue Mar 28, 2017 2:52 pm
by anutta78
Hello,

How I can split rowset with 500K rows to parts, let say 65K each?

and then use it in For each loop to write files.

Anna

Re: big rowset

Posted: Fri Mar 31, 2017 8:18 pm
by Support_Rick
If the file is already in a "rowset", then you don't have to "split it up"... just loop through the RowSet (Use a For-Each loop)...

Then, if you need to "split" at each 65k limit, just put a counter inside your loop then change destination files as you write out each record to a target file.