data for source column is too large for the specvified buffer size

#1

While I am trying to load the data from Excel file to Sql
Server using DTS, it is showing me an error message --
"data for source column is too large for the specvified
buffer size". It is showing for a particular column in
Excel file which is having format in Excel as General. And
the maximum length of the value of this field is 276
character. Is there any limitation when we pull data from
Excel?

Please let me know if anybody has any clarification on that

#2

There is this problem.

PRB: Transfer of Data from Jet 4.0LEDB Source Fails with Buffer Overflow
Error
Q281517

--
--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Rana" <rana_chakrabarti (AT) countrywide (DOT) com> wrote

Quote:

While I am trying to load the data from Excel file to Sql
Server using DTS, it is showing me an error message --
"data for source column is too large for the specvified
buffer size". It is showing for a particular column in
Excel file which is having format in Excel as General. And
the maximum length of the value of this field is 276
character. Is there any limitation when we pull data from
Excel?

Please let me know if anybody has any clarification on that

#3

Is there a workaround for this error ??

--
Posted via http://dbforums.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

data for source column is too large for the specvified buffer size

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

data for source column is too large for the specvified buffer size - 10-10-2003 , 04:05 PM

Re: data for source column is too large for the specvified buffer size - 10-10-2003 , 04:25 PM

Re: data for source column is too large for the specvified buffer size - 10-27-2003 , 09:09 AM