1Dave


I am getting the following error on my SSIS package. It runs a large amount of script components, and processes hundred of thousands of rows.

The exact error is: The value is too large to fit in the column data area of the buffer.

I redirect the error rows to another table. When I run just those records individually they import without error, but when run with the group of 270,000 other records it fails with that error. Can anyone point me to the cause of this issue, how to resolve, etc.

Thanks.




Re: The value is too large to fit in the column data area of the buffer.

jaegd


"The value is too large to fit in the column data area of the buffer" is the Message property of the exception thrown in a script component when truncation occurs on a column write. You can trap this exception by catching DoesNotFitBufferException. Since you have a large numbers of script components (presumably written by yourself), you may already know this, but this is the exception thrown.

For example, you might write some text which is more than the space allocated in the buffer. Say you have a DT_WSTR of length 49 named FortyNineCharString with a READ/WRITE usage type as in input to a synchronous script component. The following column "set" in a script component will cause the "The Value is too large ..." to be raised.

Row.FortyNineCharString = _
String.Empty.PadRight(50, CChar("."))


Instead of allowing the transform to quit, you can trap the exception and it will load up to 49 characters, leaving off any extra.

Try
Row.
FortyNineCharString = _
String.Empty.PadRight(50, CChar("."))
Catch ex As DoesNotFitBufferException
End Try


There are other alternatives, but that's most likely what is going on.