June 1, 2011 at 11:50 pm
Dear All,
My SSIS package is failing due to the below error. It was working fine till yesterday.
OS: Windows 2008 32 Bit
Db: Sql Server 2005
[font="Courier New"]A buffer failed while allocating 436904 bytes. End Error Code: 0xC0047011
Description: The system reports 61 percent memory load.
There are 8578285568 bytes of physical memory with 3271319552 bytes free. There are 2147352576 bytes of virtual memory
with 116219904 bytes free. The paging file has 21315309568 bytes with 16407076864 bytes free. End Error Error: 2011-06-02 03:04:11.51
Code: 0xC02020C4 Description: The attempt to add a row to the Data Flow task buffer failed
with error code 0x8007000E. End Error Error: 2011-06-02 03:04:11.51 Code: 0xC0047038 Source: M... The package execution fa... The step failed.[/font]
Looking for a solution.
June 2, 2011 at 2:02 am
I wonder if your package is running on the same sql box as your destination and that they are both battling it out for memory resource?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply