SQL Server Agent Job Error with SSIS Package

Question

 

Hi, I have a ssis package which is running successfully from ssis server after importing into intergrations services server(deployment), but when I ran it as job its giving the following error message. The package is running successfully in local machines as well. My package is getting the data from DB2 servers using OLE DB provider for DB2. Find the error message below.

 Code: 0xC0202009    
Source: sample Connection manager "<connectionName>"    
Description: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred.
Error code: 0x80040154.  An OLE DB record is available.  Source: "Microsoft OLE DB Service Components"  Hresult: 0x80040154 
Description: "Class not registered".  End Error  Error: 2010-12-16 23:55:12.72     Code: 0xC020801C    
Source: <Data flow task name>  
Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. 
The AcquireConnection method call to the connection manager "<connectionName>"  failed with error code 0xC0202009. 
There may be error messages posted before this with more information on why the AcquireConnection method call ... 
The package execution fa...  The step failed.

---

Sateesh Maduri

Answer 1

Hello Sateesh,

Have you installed the DB2 provider driver also properbly on the server where SSIS is running? Do the account the SQL-Server Agent is running under have enough access rights for the DB2 database?

---

Olaf Helper ----------- * cogito ergo sum * errare humanum est * quote erat demonstrandum * Wenn ich denke, ist das ein Fehler und das beweise ich täglich http://olafhelper.over-blog.de

Answer 2

Hi Sateesh,

Any progress?

---

Regards,
Tom Li