Hi all

I am trying to import a text file with with a Fixed field length
greater than 4096 characters.
In the connection properties I am not able to set any position
after 4096. Is this a real SQL Server limitation or is there
somewhere a switch to set (maybe set to 8192)??

Thanks for any comment!

Best regards
Frank

Hi Frank,

"Frank Uray" wrote
SQL Server tables are limited to 8kb, so you get a warning when your
columns seems to be greater then 8kb, and unfortunately the UI for fixed
column length won't handle such big columns.
With the actual Version of the SQl Server its no problem to load great text
data into text columns but you have to specify that ;-)
Could you use delemited columns instead of fixed size, that would work
regardless of the size?
The only other way to get more data from a text file into SQL Server is
with the Bulk Copy function, with the bulk insert task or the bcp.exe tool.
There you should be able to specify fixed column length.

Helge