Script Component Task - The value is too large to fit in the column data area of the buffer. -
07-17-2006
, 08:35 PM
Hi,
Excuse my cross posting.
I'm using Script Component Task to do custom transformation.
I add 12 output columns in output0.
5 of these columns is DT_STR and their length is 4, 3 is DT_STR 2, 3 is
DT_STR 12 and 1 is DT_I4.
When executing the package ,I get an exception as below.
The value is too large to fit in the column data area of the buffer.
at Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.Se tString(Int32
columnIndex, String value)
at Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.se t_Item(Int32
columnIndex, Object value)
at Microsoft.SqlServer.Dts.Pipeline.ScriptBuffer.set_ Item(Int32
ColumnIndex, Object value)
at
ScriptComponent_04dc3685b8d744898f09d88716141989.O utput0Buffer.set_isjsst(String
Value)
at
ScriptComponent_04dc3685b8d744898f09d88716141989.S criptMain.Input0_ProcessInputRow(Input0Buffer
Row)
at
ScriptComponent_04dc3685b8d744898f09d88716141989.U serComponent.Input0_ProcessInput(Input0Buffer
Buffer)
at
ScriptComponent_04dc3685b8d744898f09d88716141989.U serComponent.ProcessInput(Int32
InputID, PipelineBuffer Buffer)
at
Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHo st.ProcessInput(Int32
inputID, PipelineBuffer buffer)
I debug and find the execption comes form output0Buffer set value.
I alse do some testing,
1. Create a simple package wiht same Script Component Task and find no
exception.
2. Remove some output0 columns and find no exception.
It seems to be more output columns will cause an exception.
It's very confusing me...
Any help is very appreciated. |