dbTalk Databases Forums  

Buffer Size

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Buffer Size in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Sreenath
 
Posts: n/a

Default Buffer Size - 11-12-2004 , 11:58 AM






Hi,
I am trying transfer data from Excel file to database using Datapump.
I have few 10 rows empty for a column and 11th row has lot of data with CRLF
and LF. The datapump is complaining about the size of the data. I am
getting message
"Data at source column 9 is too big than the allotted buffer size"

If I copy that cell data into a a separate file, the size of the file is
around 2960 bytes and the disk size is 4KB. and in the properties of the
Datapump, I changed the buffer size to 9999 and column size in the database
is 8000.

And I am still getting the same error.
Any suggestions?
thanks,
Sreenath

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.