dts import text file -- max char per line 352?

I am trying to import a text file into my table.

However, the max varchar length is automatically set to 352.

It needs to be longer. Even after manually changing it, sure enough it truncates after 352.

(We put the first 16 characters into one field, and then try to get the next 800, but it only allows 352)

Any ideas?

`LeThe VARCHAR() datatype can be up to 8000 characters long. If you need more than that, you have my condolences and you need to resort to a TEXT column instead.

I'm not sure why your data is only importing 352 characters. 255 is a common problem, where people don't reset the maximum column width supported by Query Analyzer from the default value. I don't think I've ever seen 352 as a limit.

-PatP|||Don't have answer to question but Pat, how do you modify the max column width in QA to > 255 characters ?

Cheers|||Hit Shift-Ctrl-o, click the results tab, near dead center.

-PatP|||Pat
Thx that's really cool !