Exporting database to CSV files
Posted on 2010-09-21
Pardon me for posting this in slightly the wrong place. I don't see any option for SQL in general or SQL 2000.
I need to export a SQL2000 data to CSV files. One for each table. Everything I am seeing says to use DTS. Following the examples I have found, I seem to be missing a step. The screen shots show a step where you can choose what tables are exported. I'm not getting that option. I get a drop down of all the tables, so I can only pick one.
If there is a way to make this work, or someone can point out another way to export all the table to individual CSVs, that would be great.