Hi, I am trying to export tables from sql server 2005 to flatfiles(.csv).But my concern is i need to get an output in such a way that all the characters must be in double quotes and numerics should not be in double quotes. Example: "sqlserver",2005,"export","wizard",555 It would be great if some one can suggest what i need to select in options while exporting.

Hello, I don't think so Export Wizard will provide you this functionatly on column level. You can Select Text Qualifier " and it will put "" around your all columns, You can't tell Wizard to do for few columns and don't do for others. You can create SSIS package and handle this situation there, you can build your query the way you want and them dump in Flat File. Thankshttp://sqlage.blogspot.com/

I am agree with Aamir, you can use SSIS Data Flow task and Derived Column, or changing source t-sql query to fetch data as you need: surrounded with double qoute on string fields. if you have problem in setting the data flow task, let us know where?http://www.rad.pasfu.com