I need to create a snapshot table based on aggregation of about 1 million rows every day. I think I have developed my package correctly, but it looks like it has an out-of-memory error (0x4004800D).
Is there any way to alleviate the problem without adding more physical memory, i.e. optimizing the ETL package? Thanks.