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

thanks