The error message "A buffer failed while allocating 104856000 bytes" in SSIS (SQL Server Integration Services) indicates that there was a problem with memory allocation during the execution of a package. SSIS uses buffers to hold and manipulate data during the ETL (Extract, Transform, Load) process. Each buffer has a fixed size, and if a buffer fails to allocate the required memory, th error occurs. In this case, the buffer was trying to allocate 104856000 bytes of memory and was unable to do so. There can be several reasons for this error:
-
Insufficient system memory
-
Large data volume
To resolve the issue, you can take the following steps:
-
Review the package design
-
Optimize buffer size and row size (Reducing the buffer size should resolved the issue)
-
Increase memory allocation
-
Split large data sets
You can find more details in the following documentations:
https://cdn.cdata.com/help/RDJ/rssis/pg_destinationtask.htm#bulk-operations
