ssis buffer size memory issue

Question

Hi Expert,

facing memory issue in ssis. it is on 64 bit also increased buffer size and rows to 10000000 but still same error memory

Answer 1

Currently lookup cache in full cache mode ... is it harm if we do it on no cache or partial cache

Answer 2

Hi @Shambhu Rai ,

This error means your system is running out of memory before the buffer pool has reached it's limit. There are two data flow properties you want to look at:

DefaultMaxBufferSize - Sets the maximum memory usage for buffer
DefaultBufferMaxRows - Sets the maximum rows to buffer

You may also have a try to run 64 bit mode.

Details you may refer:
https://www.sqlservercentral.com/articles/the-defaultbuffermaxrows-and-defaultbuffersize-properties-in-ssis

Regards，

Zoe

---

If the answer is helpful, please click "Accept Answer" and upvote it.