hi all, i am after some help please, what i am trying to do is export a
table to many text files. the way i would like to do this is to read
all the rows from a table called transout and then export the first 100
rows to a text file (numbered sequencially), then read thew next 100
rows and export them to the next text file, and so on until all the
rows have been exported.

An example would be that the table could have 963 rows (will be least
or more), and i would create 10 txt files each with 100 rows with the
files numbered 1 to 9 and file 10 would hold 63 rows.

i would like to accomplish this within an sql dts package using an
activex script.

any suggestions would be nuch appreciated. thanks