I have a package that loads data from a SQL server source. After extracting records it will determine the differences between source and target using 'table difference component'.
It's a daily running package. Most of the days this will run fine but some days the package fails and gives the following error message:
Source: DFT_STG_APR_Activity_Aud_Members Table Difference [215]
Description: System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown. at Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.get_Item(Int32 columnIndex) at CozyRoc.SqlServer.SSIS.TableDifference.InputInformation.AddRow(PipelineBuffer buffer) at CozyRoc.SqlServer.SSIS.TableDifference.ProcessInput(Int32 inputID, PipelineBuffer buffer) at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostProcessInput(IDTSManagedComponentWrapper100 wrapper, Int32 inputID, IDTSBuffer100 pDTSBuffer, IntPtr bufferWirePacket) End Error Error: 2016-08-22 00:21:32.78 Code: 0xC0047022 Source: DFT_STG_APR_Activity_Aud_Members SSIS.Pipeline Description: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "Table Difference" (215) failed with error code 0x8007000E while processing input "New Data Flow" (231). The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running.
But when I rerun the package it runs fine. Can any body help me with this?
