query analyzer returning messed up data

[ftw]

I am using SQL7 Query Analyzer. A simple select * from myMLSview and
then I save results as a .csv file has the commas messed up in quite a
few places. The data is messed up before I save it to the .csv file. So
there are blank spaces being added here and there causing them to read
as 'add comma' when saving to .csv format. Even the column data is
messed up... example: ,photo_mod_time,photo_mo,d_date, should read
,photo_mod_time,photo_mod_date,
I have a view on a remote MS-SQL7 Server, the view has about 200
columns and the data returned from the my querys can be from 10 to 25MB
in size. Connection is via Roadrunner/cable. Should I use another
method, maybe command line? Any suggestions?

[Simon Hayes]

I have no idea why the commas are messed up, but in general bcp.exe or
DTS would be a better way to create a .CSV - it's probably faster, and
you don't have to do anything manually as you can just script it and
run a batch file. There are more details in Books Online.

Simon

[ftw]

Do you know any good net sources of info to learn DTS?

[Simon Hayes]

"ftw" <sp**********@yahoo.com> wrote in message
news:11**********************@o13g2000cwo.googlegr oups.com...

Do you know any good net sources of info to learn DTS?

http://www.sqldts.com/

And Books Online, of course.

Simon