I m using remote database connections. But not sure why i am getting this error. Attached is the data-flow. Please help
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 Posts
Re: No value or variable was set for the property 'SQL execution database'2012-10-09T07:56:00ZThis is the accepted answer. This is the accepted answer.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'".