How to Prevent Parallel execution ?

  • Hi Guys,

    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.

  • Can you possibly attach a screen shot showing how things are connected?

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply