error while using variable in sql transform in bods dataflow

[former_member186160]

Hi all,

i am getting syntax error while using variable within sql transform in bods dataflow.

in the below script $GV_DB is the global variable that i am populating with the required value in a script prior to the dataflow.

same thing is working at all the places except this one dataflow.

can anyone please suggest on this?

select

*******

from

[$GV_DB].[dbo].[table_XXXX]

join

*****

******

Regards,

swetha

[Former Member · Accepted solution]

Hi Swetha N,

First give correct table name with schema name with out variable and update schema. AFter updating schema you can use variables.

[former_member186160 · Accepted solution]

HI Ravi,

i updated schema with correct table name, which didnt give any error, also loads correctly.

but when i come back and update to a variable, then the validation doesnt give any error, but the run time error gets generated saying syntax error.

Please suggest.

[Former Member · Accepted solution]

Hi Swetha,

Can you post your full query here