SAP Knowledge Base Article - Preview

1976763 - Error : "DTS_E_OLEDB_EXCEL_NOT_SUPPORTED" when running SSIS packages in BPC MS 10.0

Symptom

When custom packages are migrated from BPC 7.5 to BPC 10.0, they are not run successfully from Data Manager. These are custom packages which incorporate some BPC functionality. When the packages are run from  EPM Add-In the following error occurs:

"Excel Connection Manager: SSIS Error Code DTS_E_OLEDB_EXCEL_NOT_SUPPORTED: The Excel Connection Manager is not supported in the 64-bit version of SSIS, as no OLE DB provider is available."


Read more...

Environment

  • SAP Business Planning and Consolidation 10.0, version for Microsoft.

  • Windows Server 2008 R2 platform.

  • SQL Server 2008 SP2 or SP3 database.

  • Visual Studio (or Business Intelligence Design Studio) 2008 (32-bit).

Product

SAP Business Planning and Consolidation 10.0, version for Microsoft ; SAP Business Planning and Consolidation 7.5, version for Microsoft

Keywords

DTS_E_OLEDB_EXCEL_NOT_SUPPORTED, no OLEDB provider, 64bit,32bit,64-bit,32-bit,bit,conversion, upgrade,migrate,migration,Excel,Data Manager,DM,package,OLEDB,support,runtime,mode , KBA , EPM-BPC-MS , Microsoft Version , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.