Flat file text delimiter

I am using SQL2005 management studio to export the data from a table to a
flat file. If I include a text delimiter it adds it to every column, i have
checked the columns with the edit transforms button and some of them are
ints. Is there a setting that I am missing that needs to be enabled so that
the text qualifier is applied properly.

Thanks for any help
Tim

Try www.sqlscripter.com to export data incl. text qualifiers.
It's free.


"tjfdownsouth" wrote:

> I am using SQL2005 management studio to export the data from a table to a
> flat file. If I include a text delimiter it adds it to every column, i have
> checked the columns with the edit transforms button and some of them are
> ints. Is there a setting that I am missing that needs to be enabled so that
> the text qualifier is applied properly.
>
> Thanks for any help
> Tim