data too large for specified buffer size

• Justin Miles

  SSC Enthusiast

  Points: 144

  More actions

  November 17, 2005 at 7:56 am

  #92296

  Hey all,

  I have a DTS package that is just moving data from an Access DB into a SQL table. When I run it I get the following error:

   

  Data for source column 17 'p' too large for the specified buffer size

   

  I tried following this KB article (which has worked for me in the past) (http://support.microsoft.com/default.aspx?scid=kb;EN-US;281517), but modifying the registry doesn't seem to help.  I also tried inserting 500 spaces in my first row. that didn't help either. I'm pretty stuck here, any help is appreciated.

   

  Thanks,

  Justin Miles

   

• Justin Miles

  SSC Enthusiast

  Points: 144

  More actions

  November 17, 2005 at 8:32 am

  #604437

  Nevermind... I was trying to put the data into the wrong column.  I changed it to nText and it all works now.

   

  Thanks anyways!