February 23, 2009 at 12:08 am
Hi
I have a package with several tasks (10). I have a precedence constraint set between 2 tasks (between no.5 and no.6) that is set to constraint (true) and expression. Both must evaluate too true to move to the next task. This works fine but when the control flow completes task no.6 it stops and doesn't continue to the remaining tasks (no's 7-10).
Any ideas would be appreciated.
February 23, 2009 at 1:04 am
Strange. And if you remove the constraint it works ok? Are you sure that the problem is linked to the constraint?
Phil
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
February 23, 2009 at 1:38 am
Yes, the package works fine without the constraint and expression
February 23, 2009 at 1:44 am
Probably It should not happen... Its really strange. Better to give some more details related to Control Flow...
February 23, 2009 at 1:52 am
I have attached a screen shot of it
February 23, 2009 at 2:57 pm
Can anybody else come up with some ideas that might help?
February 23, 2009 at 3:11 pm
I wonder if it could be because you have 2 precedence constraints going to that item and only one of them has it's condition met.
Try removing the constraint from the disabled item to see if it makes a difference.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
February 23, 2009 at 3:19 pm
Hi Alvin
Thanks for the reply.It appears that is the case. What's the best way to steer the control flow to do one of 2 tasks based on a variable value?
February 23, 2009 at 3:31 pm
I need to know why do you have that dataflow disabled before I suggest a solution.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
February 23, 2009 at 3:36 pm
i disabled it when i was trying to figure out what was going wrong. The problem seems to be when it gets to the task with 2 precedence constraints coming into it then one doesn't have a result ie success,failure, or completion as it hasn't run the task that was skipped due to the expression. Is there a way to ignore the constraint that doesn't have a result?
February 23, 2009 at 3:42 pm
Will you ever have a situation where both the pre 2008 and the 2008 onwards dataflows both get executed during the same run?
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
February 23, 2009 at 4:00 pm
Thanks for your help Alvin, I've made some changes to the sql to accommodate this.
February 23, 2009 at 4:01 pm
May I ask what?
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
February 23, 2009 at 4:14 pm
the sql references a table with years that are to be collected, for pre 2008 i used less than 2008 and whatever was in the table. So if year in the table is greater than 2008 then it returns nothing. The same goes for post 2008
Thanks again
February 23, 2009 at 5:46 pm
Now that I think of it, I have had this situation in the past too - I had a very elegant (or so I thought) control flow and I discovered this problem. It's as if the package decides that it should wait for input from the preceding process before continuing. That input never arrives, so the package hangs.
I ended up adjusting my package to avoid this scenario.
Phil
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 15 posts - 1 through 15 (of 15 total)
You must be logged in to reply to this topic. Login to reply