I am using the DTS wizard to export data from a table to a CSV. I have a
varchar(7000) field that is getting truncated around 255 charachters.

Is there anyway to work around this truncation, so I am not losing
information from this field when exporting to CSV?

Open your package,
Package --> Disconnected Edit --> Connections --> your text file name -->
OLE DB Properties --> Max characters per delimited column --> change the
value from 255 to the numbers you prefer...

Hope this help

Ed



"DTSNovice" wrote:

We detail the problem here

DataPump truncates delimited fields to 255 characters
(http://www.sqldts.com/default.aspx?297)

--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"DTSNovice" <DTSNovice (AT) discussions (DOT) microsoft.com> wrote