Topic
1 reply Latest Post - ‏2012-10-09T07:56:00Z by SystemAdmin
sqwnb
sqwnb
11 Posts
ACCEPTED ANSWER

Pinned topic No value or variable was set for the property 'SQL execution database'

‏2012-09-27T03:23:17Z |
HI,
I m using remote database connections. But not sure why i am getting this error. Attached is the data-flow. Please help
Updated on 2012-10-09T07:56:00Z at 2012-10-09T07:56:00Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    203 Posts
    ACCEPTED ANSWER

    Re: No value or variable was set for the property 'SQL execution database'

    ‏2012-10-09T07:56:00Z  in response to sqwnb
    Hi,

    Normally a "SQL execution database" should be specified for the whole dataflow (let's suppose it's DB1) - then, in each operator when you specify the table/view/UDF, it's supposed to be located in DB1 by default unless you choose the "remote database". In that case, another DB connection should be specified clearly. Otherwise, you will get the error "No value or variable was set for the property 'SQL execution database'".

    Thanks,
    Wei.