April 15, 2013 at 4:40 am
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.
April 15, 2013 at 4:49 am
Can you possibly attach a screen shot showing how things are connected?
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply