I need some help. I have a package which has two sequencontainers. One has data flow task & other an Execute SQL task. There are two send mail tasks for success and failure and are connected by both the containers. By using a variable I make sure that only one of the containers execute. On it's success or failure, the respective mailer task should run. The precendence constraint towards mailer tasks are fixed on "LOGICAL OR".
Problem I am facing is, as soon as either of the sequence container starts running, the Send mail tasks for Success starts running. It doesn't wait for the complete execution to check whether it success or failure. And if by chance the tasks fail, then the user gets both mails for Success & Failure. How can I correct this behavior ? MaxConcurrentExecutables is set to -1.
Screenshot is now attached.