Skip to Content
0

error while using variable in sql transform in bods dataflow

Sep 07, 2017 at 11:01 AM

75

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Ravi kiran Pagidi Sep 07, 2017 at 04:44 PM
0

Hi Swetha N,

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

Show 2 Share
10 |10000 characters needed characters left characters exceeded
Former Member

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.

0

Hi Swetha,

Can you post your full query here

0