Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 6:03 AM
Points: 7,078, Visits: 17,182
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.

Never attribute to malice that which is adequately explained by stupidity
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