SSIS Package fails with Runtime Interopservices Error

1

I have this SSIS package that used to run fine until a month ago. It started to fail with the following error code, but it ran fine after I restarted the process again. I've tried running it all day today but to avail.

The code is taking everything from excel file and pumping it to IBM DB2 table. I know the error says that there is not enough storage, but I have another another SSIS task that is 5 times its size in terms of steps, but it runs flawlessly.

Any insight into this would be much appreciated!

Error: System.Runtime.InteropServices.COMException (0x80070008): Not enough storage is available to process this command. (Exception from HRESULT: 0x80070008) at Microsoft.SqlServer.Dts.Pipeline.Wrapper.IDTSManagedComponentWrapper100.GetBLOBData(IDTSBuffer100 pIDTSBuffer, Int32 hRow, Int32 hCol, UInt32 dwOffset, UInt32 dwCount) at Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.GetString(Int32 columnIndex) at Microsoft.SqlServer.Dts.Pipeline.ADONETDestination.GetBufferDataAtCol(PipelineBuffer buffer, Int32 iCol) at Microsoft.SqlServer.Dts.Pipeline.ADONETDestination.ProcessInput(Int32 inputID, PipelineBuffer buffer) at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostProcessInput(IDTSManagedComponentWrapper100 wrapper, Int32 inputID, IDTSBuffer100 pDTSBuffer, IntPtr bufferWirePacket)

sql-server
sql-server-2008
ssis
db2
asked on Stack Overflow May 10, 2016 by 2136gamer • edited May 10, 2016 by Felix Pamittan

0 Answers

Nobody has answered this question yet.


User contributions licensed under CC BY-SA 3.0