Error in SQL server 2008 Connection manager | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Error in SQL server 2008 Connection manager

Hi 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
Code: 0xC0202009
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.



Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |