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

error executing ssis from sql agent Expand / Collapse
Posted Thursday, May 8, 2014 10:38 AM


Group: General Forum Members
Last Login: Wednesday, September 23, 2015 7:37 AM
Points: 125, Visits: 1,119
i have strange sssis package runs in sql server 2005 calling via sql agent file system, package use connection string to connect for sql server 2008 where data need to load from file. string is used Provider=SQLOLEDB.1;Integrated Security=SSPI; it has been failing intermittently. Anyone has similar issue and fixes for this issue? when i run from bids in sql server 2005 box it runs fine. sql error: DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. Hresult: 0x80004005 SQL Server does not exist or access denied."
Post #1569015
Posted Tuesday, May 13, 2014 12:23 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, August 27, 2015 12:19 PM
Points: 288, Visits: 813
Sounds like Agent permissions. Can't tell ya much more than that as someone else here handles all config and security issues at server level.
Post #1570501
Posted Tuesday, May 13, 2014 3:21 PM



Group: General Forum Members
Last Login: Yesterday @ 2:09 AM
Points: 15,501, Visits: 13,163
When you run a package through a SQL Server Agent job, it uses the permissions of the Agent service account.
You either give that service account sufficient permissions on the SQL Server box, or you use a proxy to delegate permissions.

How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at SQLKover.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1570563
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse