big rowset

[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

[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.