I'm trying to call a report via the web server ReportServer/ReportExecution2005.asmx?wsdl.
I've got an odd error occurring which would appear to be permissions related - but it not that simple it appears.......
I'm executing my package as a service account (let call it group\svc-myaccount). This account has access to report server and can browse and run reports via report manager. When I run the ssis package I get the following error (I've stripped out lots of unnecessary blurb): Code
: 0x00000001 Source:
Render Report Description:
System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.InvalidOperationException: Unable to generate a temporary class (result=1). error CS2001:
Source file 'C:\Windows\TEMP\j0qxckdq.0.cs' could not be found error CS2008:
No inputs specified
we've granted all permissions to C:\windows\temp with no success.
we've also specified the group\svc-myaccount account as a local admin and it doesn't work.....
but!..... if I run the job using my group\ADM account (which has local admin rights) it works!?!?!
So I'm a little lost - has anyone done this before - can any help?
our deadline is fast approaching, so any help would be gratefully received.
MCITP: Business Intelligence Developer (2005)