Source Data too large for Buffersize

• popsalot

  Newbie

  Points: 3

  More actions

  September 7, 2003 at 10:18 am

  #106585

  Moving data from Excel Spreadsheet to table using DTS. Get following error on one row in the SS:

  Error Source: Microsoft Data Transformation Services (DTS) Data Pump

  Error Description:Data for source column 3 ('Description') is too large for the specified buffer size.

  Error Help File:sqldts80.hlp

  Error Help Context ID:30701

  Column in question is 555 bytes long.

  Is there a setting or something that governs the offended buffer size I can adjust? If so, how/where?

• Steven.

  SSCrazy Eights

  Points: 9806

  More actions

  September 8, 2003 at 1:40 am

  #472966

  This link should solve your problem

  http://support.microsoft.com/default.aspx?scid=kb;en-us;Q281517

  Steven