I have an ExecuteSQL task that uses a variable as an input. The variable is made up of several other variables concatenated together. It was working fine but I changed the name of one of the "other" variables and now it does not work.
I get this error:
Type of variable "VariableName" is not a string.
The "Evaluate Expression" of the variable works fine and the "Parse Query" in the "Execute SQL Task Editor" says the query parses correctly.
I changed the name of the variable by adding a "1" to the end of it.
What is wrong
Fred