Error in SQL server 2008 Connection manager | SQL Server Performance Forums
SQL Server Performance Forum – Threads Archive
Error in SQL server 2008 Connection managerHi All,
We are using SSIS ( SQL server 2008 ) for porting data from a DB2 database to another SQL server DB.
We have established OLE DB connetion to the DB2 database and the credentials are stored in Connection manager.
However, sometimes the SSIS package fails with the below error.
Started: 11:30:00 AM
Error: 2010-10-31 11:40:47.93
Source: XYZ Connection manager"DB2database.134744"
Description: SSIS Error CodeDTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E4D.
An OLE DB record is available. Source: "IBM OLE DBProvider for DB2" Hresult: 0x80040E4D Description: "SQL30082N Security processing failed with reason "3"("PASSWORD MISSING"). SQLSTATE=08001
Please note that the error is intermittent and not happening all the time.
Kindly advise what could be root cause of this issue.