Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
collie
Constraint Violating Yak Guru
400 Posts |
 Posted - 2009-09-25 : 18:20:28
|
| Hi,I have a few data tasks. In the one data flow task i use a lookup component set to redirect rows at failure. The red arrow is connected to a script component where i set the value of a variable to True. I than proceed from the script component to an oledb command where i update a log table that i have in the db.The green arrow from the lookup transformtion is connected to another oledb command where i update rows.Now I want the variable in the script component to only be set to True if the lookup fails. However, regardless the variable is set to True. I know this coz i have a message box in the script.This data flow is connected with a precedence constraint to another data flow. I set the expression value so that the following tasks won't get executed if the variables value is True. However, as i mentioned above the value always becomes True as regardless of whether there was a match in the lookup that script component gets executed.How can i work around this? It's important that if one value doesn't have a lookup i update the error table in the db and don't continue with the rest of the tasks. ThanksWhisky-my beloved dog who died suddenly on the 29/06/06-I miss u so much. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-09-29 : 01:04:37
|
| have you added conditional constraint using the variable after the expression? |
 |
|
|
|
|
|
stop package execution based on condition