June 4, 2007 at 6:46 am
I am running an SSIS package which stops with an “exception in user code”:
The value is too large to fit in the column data area of the buffer.
at Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.SetString(Int32 columnIndex, String value)
at Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.set_Item(Int32 columnIndex, Object value)
at Microsoft.SqlServer.Dts.Pipeline.ScriptBuffer.set_Item(Int32 ColumnIndex, Object value)
at ScriptComponent_72ffc10df7ef4656aaa8e38598a20064.Input0Buffer.set_LocalCode(String Value) in dts://Scripts/ScriptComponent_72ffc10df7ef4656aaa8e38598a20064/BufferWrapper:line 199
at ScriptComponent_72ffc10df7ef4656aaa8e38598a20064.ScriptMain.Input0_ProcessInputRow(Input0Buffer Row) in dts://Scripts/ScriptComponent_72ffc10df7ef4656aaa8e38598a20064/ScriptMain:line 93
at ScriptComponent_72ffc10df7ef4656aaa8e38598a20064.UserComponent.Input0_ProcessInput(Input0Buffer Buffer) in dts://Scripts/ScriptComponent_72ffc10df7ef4656aaa8e38598a20064/ComponentWrapper:line 29
at ScriptComponent_72ffc10df7ef4656aaa8e38598a20064.UserComponent.ProcessInput(Int32 InputID, PipelineBuffer Buffer) in dts://Scripts/ScriptComponent_72ffc10df7ef4656aaa8e38598a20064/ComponentWrapper:line 21
at Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.ProcessInput(Int32 inputID, PipelineBuffer buffer)
Below an excerpt of the script containing the line 93 mentioned in the error message.
Case "IR1"
Row.CompanyCode = CompanyCode.ToLower
Row.LocalCode = Row.ir1 'line 93
If Row.ir1_IsNull Then
Row.IsGood =
False
Else
Row.IsGood =
True
End If
The component which contains the script scans a SQL Server table and marks certain rows in order to be extracted by the following component.
Oddly enough the very same table with the same data has been scanned successfully many times without incident.
Could somebody explain the meaning of the error message?
Thank you,
DA
June 4, 2007 at 9:36 am
This might help -
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=478437&SiteID=1
Tommy
Follow @sqlscribeViewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply