SSIS JOB ISSUE - 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 2008 Forums

SSIS and Import/Export (2008)

SSIS JOB ISSUE

Author

Topic

vipinjha
Starting Member

21 Posts

Posted - 2012-02-27 : 07:00:03

Dear All,
I am working on client side for last 15 days my job through which I am runnning SSIS packgae ia failing on daily basis.

when i am running manually it is running properly but when running through job its get failed.
i am posting the ERROR MASSAGE AND CODE

The AcquireConnection method call to the connection manager "(local).SSISLOGS1" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed. End Error Error: 2012-02-27 10:52:16.24 Code: 0xC0202009 Source: CMG ENDS OLE DB Destination [16] Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft OLE DB Provider for SQL Server" Hresult: 0x80004005 Description: "[DBNETLIB][ConnectionWrite (send()).]General network error. Check your network documentation.". End Error Error: 2012-02-27 10:52:16.24 Code: 0xC0209029 Source: CMG ENDS OLE DB Destination [16] Description: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "input "OLE DB Destination Input" (29)" failed

Please suggset what coluld be the possible way to solve this issue.

this is very important

plz advise as soon as possible

thanks in advance

regards,
Vipin jha

Vipin jha

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2012-02-27 : 08:27:21

Your SQL Agent account needs rights to a network share or another server and doesn't currently have them, whereas your user does have the rights. Get your network admin or DBA to set the right permissions to the servers for this user and it will work.

vipinjha
Starting Member

21 Posts

Posted - 2012-02-29 : 03:03:34

Thanks for your response ,
But this job is executed through MSSQL DBA which is a super user,

Please provide the appropriate way to solve this issue.

Regards,
Vipin jha

Vipin jha

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2012-02-29 : 04:54:45

But it will not have any access to network resources. Find what else the SSIS package connectsd to that is not your current server and see if the user has access to it.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-02-29 : 12:14:58

what does "(local).SSISLOGS1 connection manager point to? looks like its pointing to local server? when running from job how are you making sure its pointing to correct db? have you added a configuration for that? also is package executed in same server machine where you've your db server?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources