DTS Truncating field from 8000 to 255

hi,
I am using DTS to export to a text file and i have a field that is a
VARCHAR(8000) field. It is being truncated to 255. When I look at the
destination tab in DTS, it says that the size is 8000. Any ideas?
please advise.
rafaelhow do you know it is being truncated?. Are you doing a query using Query
Analyzer?, if so, then you have to change the value of the option Tools -
Options... - Results - "Maximum characters per column", the default is 256
and the max value is 8k or 8192.
AMB
"Rafael Chemtob" wrote:

> hi,
> I am using DTS to export to a text file and i have a field that is a
> VARCHAR(8000) field. It is being truncated to 255. When I look at the
> destination tab in DTS, it says that the size is 8000. Any ideas?
> please advise.
> rafael
>
>|||Hi,
Looks like you got problems while retrieval. If it is a problem with
retrieval then use the below commands:-
SET TEXTSIZE { number }
select @.@.textsize
See books online for more details.
Thanks
Hari
SQL Server MVP
"Rafael Chemtob" wrote:

> hi,
> I am using DTS to export to a text file and i have a field that is a
> VARCHAR(8000) field. It is being truncated to 255. When I look at the
> destination tab in DTS, it says that the size is 8000. Any ideas?
> please advise.
> rafael
>
>