Question Re: error while using variable in sql transform in bods dataflow in Technology Q&A

error while using variable in sql transform in bods dataflow

former_member186160 — Thu, 07 Sep 2017 11:01:13 GMT

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 — Thu, 07 Sep 2017 16:44:47 GMT

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

former_member186160 — Sat, 09 Sep 2017 22:49:17 GMT

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 — Mon, 11 Sep 2017 15:44:25 GMT

Hi Swetha,

Can you post your full query here