dumping large amounts of data from sql server to a text file

[alchemy9]

what is the best way to extact a lot of data from sql server to a text file,
(10's of millions of rows),

the sql query will be along the lines of select * from atable

[Ikar]

Use TMSTable or TMSQuery with FetchAll := False and Unidirectional := True.
Also you can use ReadOnly := True (it may give a little impact on performance)