Thanks, however, now that i built it, i am looking work/experiment with it for a few days.
I am now facing the following situation-(am not sure if i should create separate topic for this)--
In one package
1] Import data(source)
2] Multicast to 3 Lookups
3] I then do insert and update accordingly
There are over 8000 rows in the source table, when the package executes, it caches 4,300 rows (since i set it to full cache mode), then does a lookup of 2,100, 4300 and 2161 rows.
It then does an update or insert accordingly, but the problem is when it does this forst 'batch' , the flow 'pauses'. I am not sure at this point what is going on.
Has the package finishes executing, has it run into an error(nothing is visible since it stays in the "yellow" ) mode.
It inserts the "error" fields also correctly, so the settings looks correct, but im not sure why it seems to hang.
IF anyone has any idea please do let me know...!