Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 DTS Buffer import error TEXT-> SQL7

Author  Topic 

kathunter
Starting Member

35 Posts

Posted - 2002-11-05 : 17:25:53
I am trying to import a text file into SQL7.

One of the fields is varchar(7500) and the data I am trying to insert in this test is only 5-600 characters. It gives me a "too large for the specified buffer size."

If I trim the field to 254 characters it sinserts fine.
What confuses me is that I am inserting it into a varchar(7500) not varchar(256) and I have edited my registry settings suggested in the kb article.

Any help is appreciated.
Kat
------------

I should have taken the blue pill

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2002-11-05 : 18:14:21
Which KB article are you looking at ?
At a guess, it sounds a bit like this problem http://www.sqlserver.co.nz/content/content.asp?article=98

Damian
Go to Top of Page

kathunter
Starting Member

35 Posts

Posted - 2002-11-05 : 18:50:43
It does sound like that problem, but the solution does not fix my problem, acually my reg setting was already as high as they recommend.
Go to Top of Page
   

- Advertisement -