Hello all. I'm trying to Import (using DTS wizard) a
fairly large file. When I get to the screen where I
specify the starting/ending column positions, the DTS
wizard won't let me go beyond the 4095th column. My
record is 4288 characters. Is there a limitation on the
size of a record I can import?

Hope I didn't confuse anyone.

TIA
Roz

Max size of MSSQL record is 8Kb. It can create bigger but it will inform you then errors are possible.

ok, but my record length is 4,288 characters. Are you
saying the max record size is 8,000 characters? I'm SQL
2K by the way.

thanks
Roz