I have a scripting component that concatenates ntext fields. It was running just fine yesterday doing welll over a million records and for some reason today there seems to be a ghost in it. It can handle it just fine if i put say 4k records in the buffer...but if i put say something like 10k records I get the following error. How can i figure out how to fix this? Error HRESULT E_FAIL has been returned from a call to a COM component. at Microsoft.SqlServer.Dts.Pipeline.Wrapper.IDTSManagedComponentWrapper100.AddBLOBData(IDTSBuffer100 pIDTSBuffer, Int32 hRow, Int32 hCol, Byte[]& ppsaData) at Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.AddBlobData(Int32 columnIndex, Byte[] data) at Microsoft.SqlServer.Dts.Pipeline.BlobColumn.AddBlobData(Byte[] data) at SC_adedb0ef732c450ab22e8609cb45ff5d.vbproj.ScriptMain.Input0_ProcessInputRow(Input0Buffer Row) at SC_adedb0ef732c450ab22e8609cb45ff5d.vbproj.UserComponent.Input0_ProcessInput(Input0Buffer Buffer) at SC_adedb0ef732c450ab22e8609cb45ff5d.vbproj.ScriptMain.Input0_ProcessInput(Input0Buffer Buffer) at SC_adedb0ef732c450ab22e8609cb45ff5d.vbproj.UserComponent.ProcessInput(Int32 InputID, PipelineBuffer Buffer) at Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.ProcessInput(Int32 inputID, PipelineBuffer buffer)

Looks to me the buffer tries to allocate more memory than exists. Not sure what is your script is doping, but if it is inside a Data Flow task then consider lowering its DefaultBufferSize property (may be empty for default) value. Arthur My Blog

I changed the DEFAULTBUFFERMAXROWS of the data flow from 4000 to 1000 and it seems to be working fine now...weird