How do i import a flat file with a filed > 256. Im running a simple DTS
package with a text file source. when i import the flat file it cuts off the
filed value to 256 any ideas or work around this?

thx!

Hello John,


Are you seeing this?

http://support.microsoft.com/?kbid=247527

if not then can you tell me what version of DTS and SP?


What is the definition of the table into which you are importing?

Allan

this is sql server 2000 with sp4

the table def for this filed is set to varchar 1100
"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

Hello John,

Can you send me a sample file?

Allan

you know what my mistake...it does take in the whole field BUT does not
dislay it when i do a select * from table....is there a way to change this
setting?

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

Hello John,


Yes


I presume you are in QA.


Tools | Options | Results Tab | Maximum Characters per Column

Allan