I am trying to push records into SAP BW (PSA only) using the SAP BW Destination in SSIS 2008 R2. I am using the SAP BI Connector 1.1. The Data Flow Task fails after it has read about 1 mill. records from the data source which is a OLE DB data source on a SQL Server 2008 R2. The errors/warnings i am getting are: [SAP BW Destination [16]] Error: System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown. at Microsoft.SqlServer.Dts.SapBw.Components.SapBwSourceBWLoader.ProcessInput(Int32 inputID, PipelineBuffer buffer) at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostProcessInput(IDTSManagedComponentWrapper100 wrapper, Int32 inputID, IDTSBuffer100 pDTSBuffer, IntPtr bufferWirePacket) [SSIS.Pipeline] Error: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "SAP BW Destination" (16) failed with error code 0x8007000E while processing input "SAP BW Destination Input" (19). 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. There may be error messages posted before this with more information about the failure. [OLE DB Source [1]] Error: The attempt to add a row to the Data Flow task buffer failed with error code 0xC0047020. [SSIS.Pipeline] Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "OLE DB Source" (1) returned error code 0xC02020C4. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing. There may be error messages posted before this with more information about the failure. Is this error related to the SSIS task or is it on the SAP BW side? Fetching the same rows in i.e. a SQL Server table causes no problems. I have tried increasing the Defaultbuffersize, moving the package to a larger server with more ram. But still same issue.

Please install and see whether the latest CU can fix your issue: Cumulative update package 6 for SQL Server 2008 Service Pack 1 http://support.microsoft.com/kb/977443

Hi Gronnerup, Could you please try to remove the Data Flow Transfomation tasks to check if the issue is solved? I agree with you. The issue should be caused by the number of buffers and the size of the buffer. In order to troubleshoot this issue, you can follow this article: http://technet.microsoft.com/en-us/library/cc966529.aspx Thanks, Jin ChenJin Chen - MSFT

I am using SAP BI Connector 1.1 from the SQL Server 2008 R2 Feature Pack, and this should be the latest version. I will investigate the issue based on Jin Chens reply. Also I was wonderring if the error could be caused by non-identical data types between the SQL Server and SAP BW? This will also be a part of my investigation. I will get back with further info later :)

Hi Gronnerup, I want to check with you: Is your SAP server an big-endien server?

Hi Hong, The server is a little endian running Microsoft SQL Server 2008.