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

redirect Error Output rows to a destination and after running package check error rows to troubleshoot ithttp://www.rad.pasfu.com

The package is not even executing, its failing in pre-execute phase I have ran the same package in SSIS2008, it worked without any issues any one from microsoft, please help me on this Pavan K

Please refer to this link for the similar error message http://blogs.msdn.com/b/dataaccesstechnologies/archive/2009/11/10/ssis-error-code-dts-e-oledberror-an-ole-db-error-has-occurred-reasons-and-troubleshooting.aspx Hope this help you. Challen Fu TechNet Community Support

Hello Challen I have already seen this blog, error codes are same but the error messages are different Pavan K

any one from microsoft, please help me on this If you want help from MS themselves, it's maybe more efficient to contact customer support?MCTS, MCITP - Please mark posts as answered where appropriate.

As a temporary fix, I have implemented loop level Restartability (if ETL fails at particular loop, it will start from failure loop from the next run) Pavan K