FSchmid


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




Re: "Not a string " error

Phil Brammer


When/where do you get that error What do you do to get that error






Re: "Not a string " error

FSchmid

Either by selecting the Execute SQL task or by executing the task.

....

Now, the Execute SQL task is working. I exited BIDS and restarted it. There is no more error.

I guess if you change variable names that have been previously set up, you have to exit the BIDS program and restart it for everything to work normal again.

Is there a refresh button

Fred






Re: "Not a string " error

Phil Brammer

You likely have to go back into the Execute SQL task and reselect it.





Re: "Not a string " error

FSchmid

You would think so. I tried that and it still did not work. I even changed the SQLSourceType back to Direct Input, saved it, and then changed it back to Variable, and then selected my variable again. So far the only thing that fixes it is restarting BIDS.

Fred





Re: "Not a string " error

Phil Brammer

I cannot reproduce this behavior in the RTM version of SSIS.

Can you reproduce it, and if so, can you list all of the steps required to do so