Activex Export Multiple files
- From: samatthews@xxxxxxxxxxxx
- Date: 15 Jul 2005 06:46:09 -0700
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
.
- Prev by Date: import txt into new table
- Next by Date: DTS Package Export?
- Previous by thread: import txt into new table
- Next by thread: DTS Package Export?
- Index(es):
Relevant Pages
|
