Post reply

Data for Source too large for specified buffer size

  • 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!

  • March 19, 2004 at 3:56 pm

    #499613

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

  • March 22, 2004 at 10:22 am

    #499820

    Worked great!

    Thanks for the info!

  • 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!

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply