Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

SSIS Package to create Excel Spreadsheet fails in SQL Agent Expand / Collapse
Author
Message
Posted Thursday, July 31, 2014 4:17 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, November 11, 2014 1:19 PM
Points: 354, Visits: 212
Thanks for the suggestion... this worked for me

We were trying to figure out access issue but nothing worked before I created the folder in the mentioned location.


Suresh
Post #1598527
Posted Thursday, July 31, 2014 4:18 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, November 11, 2014 1:19 PM
Points: 354, Visits: 212
ajagadambe (5/11/2010)
Hiya, I had this problem too.

The way I solved it, was by creating a folder called "Desktop" in "C:\Windows\System32\config\systemprofile\" and I was able to run it without any problems.

I hope that helps :)


Thanks for the suggestion... this worked for me [BigGrin]

We were trying to figure out access issue but nothing worked before I created the folder in the mentioned location.

Cheers!


Suresh
Post #1598529
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse