I canīt upload data from a .txt file via bcp, all the columns are complete but the text column which is a datatype 'text' is truncated, it only holds 255 bytes, what should I do to increase de text size?

-- Anonymous, November 01, 2001

Answers

Rodolfo,

The data may actually be importing but you can only see the first 256 characters in ISQL/w or the Query Analyzer. Test it by bcp'ing out the data and looking at the text column data.

Hope this helps,

Eric

-- Anonymous, November 02, 2001