You fire up the DTS import/export wizard.
1. You select database source like pubs
2. You select TEXT FILE destination (path)authors.csv
3. You set the destination file format (the default is usually ok)
4. You select the table (or query) as the source
5. Set first row has column name option
6. You can also do transfomation
7. Finish & run (optionally you can save the package)
Kalman Toth - Database, Data Warehouse & Business Intelligence Architect
The Best SQL Server 2005 Training in the World!