Post reply

Exception in User Script

  • June 4, 2007 at 6:46 am

    #179143

    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

    #710643

    This might help -

     

    http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=478437&SiteID=1

     

     

    Tommy

    Follow @sqlscribe

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply