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.