Skip to Content
avatar image
Former Member

error while using variable in sql transform in bods dataflow

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Sep 07, 2017 at 04:44 PM

    Hi Swetha N,

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

    Add comment
    10|10000 characters needed characters exceeded