Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

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

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, October 1, 2014 6:20 AM
Points: 19, Visits: 172
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


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 11:50 AM
Points: 5,248, Visits: 12,166
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.
Post #1442248
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse