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
Posted Thursday, November 21, 2013 6:41 AM



Group: General Forum Members
Last Login: Today @ 4:20 AM
Points: 7,960, Visits: 19,077
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.

If your posting includes some T-SQL code, please surround the code with IFCode formatting tags. It helps readability a lot.
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