sql job - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2012 Forums

SQL Server Administration (2012)

sql job

Author

Topic

nord
Posting Yak Master

126 Posts

Posted - 2014-10-02 : 12:20:30

Hi,
I have run ssis using sql agent(job),but I have this error

Date 10/2/2014 10:46:03 AM
Log Job History (POS proccess)

Step ID 1
Server MARKETSOURCESQ2
Job Name POS proccess
Step Name POS

Duration 00:00:00
Sql Severity 0
Sql Message ID 0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0

Message
Executed as user: NT Service\SQLSERVERAGENT. The process could not be created for step 1 of job 0xC8C467016A2E4E40B8D0A27F7371202B (reason: Access is denied). The step failed.

can any body to help me with this error
thanks

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-10-02 : 13:22:11

Looks like there's a security issue for the service account. The package is accessing something that the SQL Server service account does not have access to.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/

nord
Posting Yak Master

126 Posts

Posted - 2014-10-02 : 15:27:29

I have another error:

Message
Executed as user: NT Service\SQLSERVERAGENT. Microsoft (R) SQL Server Execute Package Utility Version 11.0.5058.0 for 32-bit Copyright (C) Microsoft Corporation. All rights reserved. Started: 2:44:12 PM Error: 2014-10-02 14:44:12.96 Code: 0xC0011007 Source: {DE8F52B2-CDD3-4F5B-9555-4BD55578A538} Description: Unable to load the package as XML because of package does not have a valid XML format. A specific XML parser error will be posted. End Error Error: 2014-10-02 14:44:12.96 Code: 0xC0011002 Source: {DE8F52B2-CDD3-4F5B-9555-4BD55578A538} Description: Failed to open package file " C:\Users\echepeleutser\Business_Intelligence_ETL\Sales_Data_ETL\POSFeedFileToStagingTable.dtsx" due to error 0x80070005 "Access is denied.". This occurs when loading a package and the file cannot be opened or loaded correctly into the XML document. This can be the result of specifying an incorrect file name when calling LoadPackage or the specified XML file has an incorrect format. End Error Could not load package " C:\Users\echepeleutser\Business_Intelligence_ETL\Sales_Data_ETL\POSFeedFileToStagingTable.dtsx" because of error 0xC0011002. Description: Failed to open package file " C:\Users\echepeleutser\Business_Intelligence_ETL\Sales_Data_ETL\POSFeedFileToStagingTable.dtsx" due to error 0x80070005 "Access is denied.". This occurs when loading a package and the file cannot be opened or loaded correctly into the XML document. This can be the result of specifying an incorrect file name when calling LoadPackage or the specified XML file has an incorrect format. Source: {DE8F52B2-CDD3-4F5B-9555-4BD55578A538}Started: 2:44:12 PM Finished: 2:44:13 PM Elapsed: 0.157 seconds. Process Exit Code 4. The step failed.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-10-02 : 15:34:20

It's the same issue: "Access is denied". This is a security problem for the service account.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/

nord
Posting Yak Master

126 Posts

Posted - 2014-10-02 : 15:40:08

ok,what i can do with this,can you help me,please?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-10-02 : 15:43:07

You need to grant access to the service account for the paths and files in use.

You should probably move this to a location not locked down to just echepeleutser or open up the access:
c:\Users\echepeleutser\Business_Intelligence_ETL\Sales_Data_ETL
Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources