hello good afternoon, you can use global variables in "sql transform data services 4.2" because I have already tried brackets, keys, parentheses .. if nothing and I do not recognize the global variable, I want to do this:
1) select * from TABLE where field = {$ variable_global}
2) select * from TABLE where campo =[BOBJ:$variable_global]
3) select * from TABLE where field = [$ variable_global]
4) select * from TABLE where field = '[$ variable_global]'
5) select * from TABLE where field = $ variable_global
6) select * from TABLE where field = variable_global
7) select * from TABLE where field = ($ variable_global)
and what I get is the error odbc data source error operation -BODI1130199, Help please.
I just want to know if you can use the global variables or not, what else can I do to pass the value of a variable?
Thank you..