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

Issues while executing the xp_cmdshell through SSIS Expand / Collapse
Author
Message
Posted Thursday, November 28, 2013 5:16 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, September 16, 2014 5:49 AM
Points: 7, Visits: 66
E: is local drive
Post #1518328
Posted Thursday, November 28, 2013 10:39 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 6:16 PM
Points: 7,738, Visits: 9,487
And does the agent account (or the service account if you haven't set up an agent account fr xp_cmdshell) have write permissions for that file and path?

Tom
Post #1518390
Posted Thursday, November 28, 2013 9:12 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, September 16, 2014 5:49 AM
Points: 7, Visits: 66
Thanks for reply.

I don't know how but creating following directory fixed my issue..

C:\Windows\SysWOW64\config\systemprofile\Desktop
Post #1518435
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse