Skip to Content
0
Former Member
Feb 23, 2010 at 05:56 PM

Data Services / Data Integrator Global variable in SQL Transformation

226 Views

Hi

I want to use a global variable inside a SQL Transformation, but I got an error in the runtime. This makes me think there is no preprocessing of the text inside the Transformation. Is there a way to work around this ?

Can I change dynamically the contents of the SQL Transformation ?

Example:

select productid, productname from products where year = $YearGV

I tried enclosing the variable with {} [] and () but with no luck.

Any help would be appreciated.

Paolo