December 11, 2009 at 2:02 am
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.
December 11, 2009 at 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.
January 24, 2019 at 7:34 am
sarvanjonty - Friday, December 11, 2009 2:28 AMI 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 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply