May 13, 2015 at 12:10 pm
using an expression for a precedence constraint between two sequence containers.
the expression is as follows:
@rowcount_20452 == @sqlRowcount_20452
have confirmed with breakpoints and watch windows that the varchar values on both sides of equation are equal (assume evaluating to true) nevertheless the pkg stop flowing. No error, but execution of package stops.
Why doesn't the subsequent sequence container kick of processing?
--Quote me
May 14, 2015 at 4:05 am
Verify once again, it must be having two variables with the same name.
Example - One at the package level and another at the task level. So, in case you have multiple variables with the same name, but different scope then the task will use the variable with task scope.
And you must be updating the variable at the package level.
____________________________________________________________
APMay 14, 2015 at 5:47 am
One of the variables is populated by a powershell script and therein lay the bug. My eyes finally attuned to the fact that the script was outputting a line feed character at the end of the output value.
I added a -writenolines script eg. Write-host -NoNewline $sum and problem went away.
thanks for the help yesterday finding scope problem. That was pure logic and I feel I wouldn't have ever thought of scope and gotten to this point. Much thanks.
--Quote me
May 14, 2015 at 9:12 pm
Makes sense...Cheers!!
____________________________________________________________
APViewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply