Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

How to Prevent Parallel execution ? Expand / Collapse
Posted Monday, April 15, 2013 4:40 AM


Group: General Forum Members
Last Login: Monday, January 11, 2016 3:48 AM
Points: 19, Visits: 181
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.

  Post Attachments 
Error.jpg (8 views, 46.51 KB)
Post #1442245
Posted Monday, April 15, 2013 4:49 AM



Group: General Forum Members
Last Login: Today @ 12:45 PM
Points: 7,960, Visits: 19,075
Can you possibly attach a screen shot showing how things are connected?

Help us to help you. For better, quicker and more-focused answers to your questions, consider following the advice in this link.

When you ask a question (and please do ask a question: "My T-SQL does not work" just doesn't cut it), please provide enough information for us to understand its context.

If your posting includes some T-SQL code, please surround the code with IFCode formatting tags. It helps readability a lot.
Post #1442248
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse