Hi
while running ssis package below is the error faced,
Cache Transform [2]] Error: Unable to allocate memory for a new row for the main workspace buffer. An out-of-memory condition occurred.
Error: The system reports 48 percent memory load. There are 137438482432 bytes of physical memory with 70406213632 bytes free. There are 4294836224 bytes of virtual memory with 10485760 bytes free. The paging file has 146028417024 bytes with 78848417792 bytes free.
Trobleshooting done but no result:
adjustment done on buffer sizes
increased the ram of the machine(vm)