RowIndexOutOfRangeException

  • sarvanjonty

    Mr or Mrs. 500

    Points: 585

    Microsoft.SqlServer.Dts.Pipeline.RowIndexOutOfRangeException: PipelineBuffer has encountered an invalid row index value. at Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.HandleUserException(Exception e) at Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.ProcessInput(Int32 inputID, PipelineBuffer buffer) at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostProcessInput(IDTSManagedComponentWrapper90 wrapper, Int32 inputID, IDTSBuffer90 pDTSBuffer, IntPtr bufferWirePacket)

    I am using a script component which reads 2339 records, when the record length is greater that 75 i am taking first 75 chars in first row and return to o/p field and the remaining to the second row. Meaning, each single row will be processed inside the script and it will return more than record which it takes in( Asynchronous). So the script works fine for first 830 records after that it throws the error. Can anyone help to figure out what causes this error.

    Note: I am using addrow() inside the script to create output records.

  • sarvanjonty

    Mr or Mrs. 500

    Points: 585

    I was checking Endofrowsets() in the script which is not required and thats the cause for the error. Its now fixed after removing that condition.

  • meetsudhakarrao

    Newbie

    Points: 9

    sarvanjonty - Friday, December 11, 2009 2:28 AM

    I was checking Endofrowsets() in the script which is not required and thats the cause for the error. Its now fixed after removing that condition.

    I had exact same issue, in my case issue was I had copied the script component to multiple packages and there was some reference to the copied package, that was causing index out of range exception. Resolved the issue, by creating the script component from scratch for each package.

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

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