SSIS 2012 OLE DB Source issue with SSAS data source - error code 0x80004005


  • Hello:

    I have a for each loop which pulls the data from the cube by using mdx query, it is working fine for the some of the loops(iterations), after some iterations it is failing with the following error

    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 2012 Analysis Services."  Hresult: 0x80004005  Description: "Server: The operation has been cancelled.".

    OLE DB Source failed the pre-execute phase and returned error code 0xC0202009.

    am using SQL Server 2012

    Pavan K

    Tuesday, May 01, 2012 6:11 AM

All replies