exporting data to different csv files

[gojohnnygogogogo]

hello,
I have one table with about 800,000 records in it, I need to export the data to files where the value in one field is equal to others.

eg.
select * from table1 where number = '1'
this creates file1

then

eg. select * from table1 where number = '2'
this creates file2

and so on.

instead of doing indivdual queries and exports can I somehow automate this ?


thanks for any help

 

[anilkutty]

You Can use DTS to do these. Create a DTS which fires up the query and using DTS export to csv file. You can automate this by scheduling the DTS Package

 

[gojohnnygogogogo]

but how can I go through the number field automatically to create the needed queres for the files ?