Just a quick note on a frustrating error adding an AssignExpression to an SSIS For Loop Container.
The expression being added was
@[User::LoopCount] = @[User::LoopCount] + 1
which looks fine, but continually gave an error of "the equals (=) sign at position 20 was unexpected".
Changing the variable formats, and other syntactic changes didn't help. And the cause?
A space at the front of the expression. If I'd counted to position 20 I might have found it earlier, as the = sign was at position 19, but then again, probably not. Removing the space solved the error and allowed the loop to run.
