March 25, 2014 at 1:33 am
Hello
I have one package which is getting data from MSSQL server and putting it to the excel (2007 format).
When started as an administrator from Visual studio, IS, command line or SQL Agent job it works just fine.
But when using regular user (SSIS proxy in SQL Agent job) it does not return any errors, but result Excel file is just empty. It puts only firs row with headers into it.
Only difference I've found when executing as admin and regular user is a warning in package execution detailed log:
OnWarning,SERVERNAME,USERNAME,PACKAGE_NAME,{GUID},{GUID},2014.03.21 15:23:22,2014.03.21 15:23:22,-2147183868,0x,Warning: Could not open global shared memory to communicate with performance DLL; data flow performance counters are not available. To resolve, run this package as an administrator, or on the system's console.
If I add user to local administrators group it runs just fine.
Trying to search the web I've found that most causes of thet could be UAC enabled on the server. But it is not enabled.
SQLserver - Microsoft SQL Server 2012 - 11.0.2383.0 (X64)
Windows Server 2008 R2
Thanks in advance,
Olegas
March 28, 2014 at 3:44 am
Hello
Just to let everyone know, who might run into such situation also.
Under some setups process was denied an access on file, created in Default User -> Temporary Internet Files folder. (Thanks ArthurZ from another forum for a tip).
After giving access to that folder for user (or Everyone) DTS runs just fine.
Regards,
Olegas
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply