Hello All,

My source has 2.2 million of records. I'm performing the incremental load.
In the lookup transformation i used the destination table for the reference using Full cache mode.

For the first time package executed successfully but when i executed the package second time, Suddenly Package hangs while running.

Than i truncate the data from the destination table and restart the SQL Server Services.
After doing all this i executed package again and it worked but when i executed package second time, again package hangs up .

What is the problem??

I have 8GB RAM and i5 2.5 GHz Processor laptop.

• Edited by Parth..Patel Wednesday, July 01, 2015 5:47 PM

Yes RyanAB. It was memory issue. 

Thank You.