I m using remote database connections. But not sure why i am getting this error. Attached is the data-flow. Please help
This topic has been locked.
1 reply Latest Post - 2012-10-09T07:56:00Z by SystemAdmin
Pinned topic No value or variable was set for the property 'SQL execution database'
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-10-09T07:56:00Z at 2012-10-09T07:56:00Z by SystemAdmin
SystemAdmin 110000D4XK203 PostsACCEPTED ANSWER
Re: No value or variable was set for the property 'SQL execution database'2012-10-09T07:56:00Z in response to sqwnbHi,
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'".