We help IT Professionals succeed at work.

SQL Server Agent Job Error

Vipin Ellat
Vipin Ellat asked
on
184 Views
Last Modified: 2017-05-29
Hi Experts,
                    I  am facing an issue in sql server agent job for a project that I created.  Details are given below. Thanks in advance

Executed as user: NT Service\SQLSERVERAGENT. Microsoft (R) SQL Server Execute Package Utility  Version 11.0.6020.0 for 64-bit  Copyright (C) Microsoft Corporation. All rights reserved.    Started:  12:02:41 PM  Error: 2017-05-09 12:02:42.86     Code: 0xC020200E     Source: Data Flow Task Flat File Source [374]     Description: Cannot open the datafile "\\Sono\MART\Demand05082017.csv".  End Error  Error: 2017-05-09 12:02:42.86     Code: 0xC004701A     Source: Data Flow Task SSIS.Pipeline     Description: Flat File Source failed the pre-execute phase and returned error code 0xC020200E.  End Error  DTExec: The package execution returned DTSER_FAILURE (1).  Started:  12:02:41 PM  Finished: 12:02:42 PM  Elapsed:  0.922 seconds.  The package execution failed.  The step failed.
Comment
Watch Question

IT Engineer
CERTIFIED EXPERT
Distinguished Expert 2017
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Jim HornSQL Server Data Dude
CERTIFIED EXPERT
Most Valuable Expert 2013
Author of the Year 2015
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Megan BrooksSQL Server Consultant
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Vipin EllatMSBI Consultant

Author

Commented:
Hi Experts,
                    Sorry for the delay. Finally ,I got a solution.As you all people recommended ,I checked the access rights and sql agent user id is not having the access to execute the job.That's why,I got the error.Thanks all.
Jim HornSQL Server Data Dude
CERTIFIED EXPERT
Most Valuable Expert 2013
Author of the Year 2015

Commented:
Absent any meaningful asker comments all expert comments have value.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.