I have a data flow task with 2 components :
source ODBC : with more than 3 000 000 rows
OLEDB Destination : it's my table destination .
The job works perfectly every day at 2:00 AM .
But this day it fails with the folowing error message :
The system reports 97 percent memory. There are 8589463552 bytes of physical memory and 195,731,456 bytes free. There are 2147352576 bytes of virtual memory and 118149120 bytes free. The swap file is 17072041984 bytes and 2497855488 free bytes. A buffer failed while allocating 10485608 bytes. Failed to add row to output buffer.
Note that : this is my server configuration of my customer : 8 G RAM / Processor : 2,6 GHZ
I think it will be a problem of size : so what is the solutions offered for this situation (any tips to configure in SSIS or other) ?