Kevin Hill diagnoses an out-of-memory error in SQL Server Integration Services:
Notice the red sections above:
-
Not enough storage – was this physical memory, virtual memory or disk?
-
Buffer failed to allocate (10MB) – Why?
-
2% memory load – yes, this box has 1 TB of RAM…plenty for what we are doing you would think.
-
Attempt to add a row – well, yeah…if SSIS uses buffers and cannot allocate one, there are either none, or they are full. Makes logical sense to me
I won’t spoil the ending; you’ll have to read it over there.