"Information: 0x4004300A at Testing1, SSIS.Pipeline: Validation phase is beginning.

Warning: 0x80047076 at Testing1, SSIS.Pipeline: The output column "[Measures].[Distinct Count]" (18) on output "OLE DB Source Output" (13) and component "PIPELINE CUBE" (2) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.

Information: 0x40043006 at Testing1, SSIS.Pipeline: Prepare for Execute phase is beginning.

Information: 0x40043007 at Testing1, SSIS.Pipeline: Pre-Execute phase is beginning.

Error: 0xC0202009 at Testing1, PIPELINE CUBE [2]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred.

Error code: 0x80040E05. An OLE DB record is available. Source: "Microsoft OLE DB Provider for SQL Server 2014 Analysis Services." Hresult: 0x00000001 Description: "Error Code = 0x80040E05, External Code = 0x00000000:.".

Error: 0xC004701A at Testing1, SSIS.Pipeline: PIPELINE CUBE failed the pre-execute phase and returned error code 0xC0202009.

Information: 0x4004300B at Testing1, SSIS.Pipeline: "DB TEMP" wrote 0 rows.

Information: 0x40043009 at Testing1, SSIS.Pipeline: Cleanup phase is beginning. Task failed: Testing1"

My environment:

SQL Server Data Tools for Visual Studio 2013
SQL Server 2014
Windows Server 2012

Any clue why i am getting this error? - knowing that it used to be working successfully!

• Edited by AR.91 Monday, July 13, 2015 10:51 AM

https://support.microsoft.com/en-us/

Hi AR.91,

I would suggest switching to the ADO.NET Source to run the MDX query instead of using the OLE DB Source.  Too many issues with the OLE DB going against SSAS source. The one thing that you will need to do though is include a copy column to rename the column name to something that is usable through the data flow ([Measures].[Sales Amount] to just SalesAmount) and to used derived columns to convert the data type of DT_NTEXT to something meaningful that you can use like DT_WSTR and then other types.

Thanks,
Katherine Xiong