SQL Server Performance

Error in SQL server 2008 Connection manager

Discussion in 'SQL Server 2008 Integration Services' started by SARAVANANG, Nov 1, 2010.

  1. SARAVANANG New Member

    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.
    Thanks,
    Saravanan.G
    SARAVANANG, Nov 1, 2010
    #2

  2. Luis Martin Moderator

    Check:
    http://www.experts-exchange.com/Database/DB2/Q_25124066.html
    Luis Martin, Nov 4, 2010
    #3

Share This Page