Exporting long string columns

[cricketer1]

Can someone help me with how to export a table that contains a very long varchar cloumn whose length of data is over 1000 characters. This column contains HTML tags embedded with in text.
If I try exporting data the regular way to a text file from Enterprise manager, it only exports part of the coulmn. Seems like there is a max number of characters I can export per column. Can these be changed? How can I export the entire column to a flat file?

Thanks
Zaheer

 

[nikischwabe]

I am having this exact problem and I can't figure out what is causing it. When I run a query on a TEXT field that contans a large amount of text, it simply displays &quot;<long text>&quot; and when I use DTS to export it to a text file, only the first 1000 characters or so get exported??

Can anyone help? Nice one