Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

error executing ssis from sql agent Expand / Collapse
Author
Message
Posted Thursday, May 8, 2014 10:38 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, August 29, 2014 7:49 AM
Points: 104, Visits: 1,028
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
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, June 27, 2014 2:05 PM
Points: 300, Visits: 810
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


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 12:15 AM
Points: 13,642, Visits: 10,535
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 LessThanDot.

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

Add to briefcase

Permissions Expand / Collapse