December 17, 2008 at 10:28 pm
þBegDocþþProdBegDocþþProdEndDocþþFILE_PATHþþFULL_TEXTþ
the above are the headings (columns) delimited and þ as text qualifier
and the last column full_text is very very lengthy the no of records are 86 only
can any help me import this file in sqlserver 2005, the error I am getting is
error: the column data for column FULL_TEXT overflowed the disk I/O buffer
Even if I ignore this column in DTS and SSIS while importing then also the above err is seen
kindly help.
December 18, 2008 at 7:56 am
Can you attach the file to the post? That would make it possible to experiment with it. Also what build of SQL Server 2005 are you on?
This looks similar to this problem also for which there is not a fix that I can find other than what I posted over there.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply