dbTalk Databases Forums  

DTS error - Import from Excel - 'too large for specified buffer si

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


Discuss DTS error - Import from Excel - 'too large for specified buffer si in the microsoft.public.sqlserver.dts forum.



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

Default DTS error - Import from Excel - 'too large for specified buffer si - 10-28-2008 , 10:52 PM






When we try to import data from an excel, we are getting an error 'data for
source column <column name> is too large for the specified buffer size'.

We tried copying a large value for this particular column in the first 8
rows and it works. But we need a better solution where we need not manipulate
the excel file manually.


Thanks in Advance.

Regards,
Augustin

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.