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 «««123

ssis script task throws error when run from sql agent job Expand / Collapse
Author
Message
Posted Thursday, November 21, 2013 6:41 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 11:29 AM
Points: 4,986, Visits: 11,685
ForumUser3 (11/21/2013)
I am using a UNC path, not a mapped drive.


My apologies, I misread the error.

Are you able to physically log in to the SQL Server server using the service account and try to access the file directly in Explorer?



Help us to help you. For better, quicker and more-focused answers to your questions, consider following the advice in this link.

When you ask a question (and please do ask a question: "My T-SQL does not work" just doesn't cut it), please provide enough information for us to understand its context.
Post #1516408
Posted Friday, November 22, 2013 9:45 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, July 4, 2014 12:04 PM
Points: 33, Visits: 113
Sharing the folder solved the problem.

Forum User
Post #1516864
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse