I've found loads of posts with the error I'm seeing: "The type of the value being assigned to variable [XXX] differs from the current variable type".
However, I can't see anything that matches my scenario. I'm simply trying to assign a value to a variable BEFORE passing the variable to an Execute SQL Task.
I want to assign "true" or "false" to a Boolean variable called LogError, but as I got this error, I tried instead to assign 0 or 1 to it after converting it to an Int16 variable, but got the same result.
I can see all manner of posts that make me wonder what I may have problems with next when I try to pass this variable to my stored proc that's expecting a BIT, but for now, I'd love SSIS to simply assign the value to the variable!
View Complete Post