Data for Source too large for specified buffer size

• dba_user

  Default port

  Points: 1458

  More actions

  March 19, 2004 at 2:12 pm

  #60066

  I am importing an excel file into a SQL Server table using data transformation task.  I get the error, Data for source column 25('internal comments') is too large for the specified buffer size.  I went to the advanced tab and increased the buffer size to '2' , however only one line is then inserted.  I am inserting the column into a varchar(8000) field and the text file column is way below 8000.  Please help!!!

   

  Thanks in advance!

• Antares686

  SSC Guru

  Points: 125444

  More actions

  March 19, 2004 at 3:56 pm

  #499613

  May be this http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q281517

• dba_user

  Default port

  Points: 1458

  More actions

  March 22, 2004 at 10:22 am

  #499820

  Worked great!

  Thanks for the info!

• Jonathan Knowsley

  Grasshopper

  Points: 11

  More actions

  June 23, 2004 at 1:15 pm

  #511662

  I tried the workaround on Q281517 and I am still receiving the Source Column is too large for the specified buffer size error.  I am working with SQL Server 2000 on Windows Server 2003.  I am trying to import an Access table with two memo fields.  I have tried importing them as TEXT and as NTEXT with no luck.

  I have changed the registry value and I have also placed the memo field with 700 characters in the 1st rows sorted by Len(memo) DESC

   

  Thanks!