ERROR when running SSRS subscription (SQL Agent job)
this is permission issue.... I recently resolved the same issue by changing the permission to that proxy account.
check this ...
http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/0288216e-73dd-43cb-a1fb-1bee3184f1ff
let us know your observation....
Let us TRY this |
My Blog :: http://quest4gen.blogspot.com/
June 12th, 2012 8:03am
Hi,
it wasn't such case but thanks anyway. I have solved my issue by deleting RunID property value of all EXECUTE SQL AGENT JOB tasks from configuration table and it works fine now.
Free Windows Admin Tool Kit Click here and download it now
June 12th, 2012 10:37am
Hi,
I have package, which in one of it's way runs few report subscriptions () from SSRS. It works on my machine from BIDS, but when I run it on server, it says error
Code: 0xC0014054 Source: Run SSRS subscription Description: Failed to lock variable "RunId" for read access with error 0xC0010001
"The variable cannot be found. This occurs when an attempt is made to retrieve a variable from the Variables collection on a container during execution of the package, and the variable is not there. The variable name may have changed or the variable is not
being created."
Similar error is for other subscriptions, that are run by package.
Proxy User which run package has sysadmin rights.
Thanks a lot
June 15th, 2012 7:58am