Error while using Script Component

• ns.sharath

  SSC Eights!

  Points: 876

  More actions

  February 2, 2009 at 2:32 am

  #200759

  I am using a Script Component to get data and load into a table, while loading it gives me an Error

  "The value is too large to fit in the column data area of the buffer" ?

  Is there any solution to this

• Russel Loski

  SSCertifiable

  Points: 7059

  More actions

  February 2, 2009 at 4:09 am

  #936320

  Take a look at http://social.technet.microsoft.com/Forums/en-US/sqlintegrationservices/thread/7f89f61a-1fd3-41d2-903b-949c8e989f1c/

  You can use a Substring method to send only number of characters that your output column can hold.

  Russel Loski, MCSE Business Intelligence, Data Platform