VERIFIED SOLUTION i

How to avoid the "Your system is running out of virtual memory" in Sagent

The error comes when partial cache option enabled in Key LookUp transform for the large number of input records for plans.
It could be due to
  • The number of input records for PreLoad Partial Cache option
  • Large size of each input record
This error message pops up for the number of input records in the data flow rather than the number of records stored in the lookup table.Thus, it can come for even one record in the lookup table.

As a workaround, Partial Cache should be used when the count of lookup records is greater  than the count of input records. The workaround is to  use  "Cache As Found" or "Cache Whole Table".
Environment Details
UPDATED:  November 22, 2017