Posted by Erland Sommarskog on 10/02/45 11:54

panic attack (tunc.ovacik@gmail.com) writes:
> Our system is using Sql Server 2000 on Windows XP / Windows 2000
> We have a text file needs to be imported into Sql Server 2000 as a
> table.
> But we are facing a problem which is,
> Sql Server claims that it has a character size limit ( which is 8060 )
> so it cant procceed the import operation if the text file has a record
> bigger then 8060.
> The records , in the text file, have a size bigger then 8060. So we
> wont be able to import the text file.
> On the other hand it is said that Sql Server 2005 can get a record
> bigger then 8060 but
> again we couldnt be able to perform the task.
>
> As a result, i urgently need to know that how may i import the text
> file which has a record bigger then 8060 characters.?
> Any help is appreciated
> thanks a lot!!

How do you import the file? BCP, BULK INSERT or DTS?

Could you post the CREATE TABLE statement for the table in question?


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Set time for UTC
• Prev in forum: Having Problem While Importing a Text File
• Thread view: Re: Having Problem While Importing a Text File

[Reply to this message]