i just upgraded from TDP 3.3 to 3.4 and I encountered a strange error. I was defining a variable (string) by means of a SQL query. Tried both ways Execute SQL and Set Variable and tey work. When I want to use this variable in a subsequent Export to Excel activity I get an error “invalid character” (see screenshot). When I run this Export task and put in the string manually (red arrow in screenshot) everything is ok, using the variable (marked blue) I get this error. I still can finish the Export wizard but the automation script also throws this error and stops. A simple Excetute_SQL referring to the variable works fine, it seem to be Export specific.
The script worked well in 3.3.
Does anyone also have this issue?
Thanks in advance,