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
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
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 TRIALMembers 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.