Post reply

'System.OutOfMemoryException' while running SSIS package on SQL Server 2008

  • June 17, 2015 at 4:47 am

    #305135

    Hi Everyone,

    I am getting 'System.OutOfMemoryException' while running SSIS package.

    My DB Environment: - SQL Server 2008 Enterprise Edition (32 Bit)

    OS:- Windows server 2003 R2

    RAM:- 48 GB.

    Error:- The system reports 9 percent memory load. There are 51538829312 bytes of physical memory with 46818926592 bytes free. There are 2147352576 bytes of virtual memory with 60694528 bytes free. The paging file has 129964646400 bytes with 125095038976 bytes free. End Error Error: 2015-06-17 15:43:00.01 Code: 0xC02020C4 Source: Data Flow Task 3 OLE DB Source [1] Description: The attempt to add a row to the Data Flow task buffer failed with error code 0x8007000E. End Error Error: 2015-06-17 15:43:00.01 Code: 0xC0047038 Source: Data Flow Task 3 SSIS.Pipeline Description: 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. End Error Error: 2015-06-17 15:43:30.57 Code: 0xC002F304 Source: Send Mail Task Send Mail Task Description: An error occurred with the following error message: "Exception of type 'System.OutOfMemoryException' was thrown."

  • June 17, 2015 at 8:57 am

    #1806095

    Which task failed, the Data Flow Task or the Send Mail Task?

  • June 17, 2015 at 10:38 pm

    #1806255

    It is failing on data flow task.

  • June 19, 2015 at 8:31 am

    #1806706

    It looks like a buffer memory issue.

    Here is an article talking about the same problem.

    http://sqlserverscribbles.com/2013/12/03/ssis-package-fails-with-out-of-memory-errors/

  • June 22, 2015 at 3:03 pm

    #1807210

    I have changed default buffer size to 30 Mb, but still getting the same error.

  • June 25, 2015 at 4:39 pm

    #1808279

    Hi Everyone

    My issue is resolved.

    We have changed oracle provider used in data flow task. Previously it was “Microsoft OLEDB provider Oracle” now we have changed it to “Oracle provider for OLEDB”

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply