Link to home
Start Free TrialLog in
Avatar of Ganesh Yerme
Ganesh Yerme

asked on

SSIS 2012 Look Up Full Cache transformation C: Drive space getting full

Hi All,

I'm having an issue with SSIS 2012 Look up transformation . I'm querying 4.5 million records from source system. Then I will need to compare them with a destination table  (another 4.5 million records) to perform insert for new records and update for existing records.

while running this ssis package my c drive getting full.

i am using lookup full cache mode.

kindly help me to resolve this issue.



Thanks in advance.



Warm Regards

Ganesh Yerme
Avatar of Pragya shukla
Pragya shukla

This is due to full cache lookup stores the value in memory for operation. Preferred to use no cache option in this case or excute the lookup query from control flow.
This question needs an answer!
Become an EE member today
7 DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.