I have been trying to import data from an Excel file using Data Import Export Framework. The mapping and validation works but when I try to import the data into staging table - I get the below error:
Exception from HRESULT: 0xC0048021
at Microsoft.Dynamics.AX.Framework.Tools.DMF.SSISHelper.DMFEntity.ShowPreview(Boolean isComposite)
at Microsoft.Dynamics.AX.Framework.Tools.DMF.SSISHelperService.Service.ServiceHelper.ShowPreview(DMFEntity entity)
I am using Dynamics AX 2012 R3 RTM with Excel 2013. Also from a very good blog I learnt that I had to install the Access database engine that I did. Didn’t help.
If you’re using Excel 2013 like I am, the problem is caused by tge DMConfig XML file.
Go to the DMConfig.xml file in the Microsoft Dynamics AX\60\DataImportExportFramework folder and replace the PipelineComponentInfo_Multicast, PipelineComponentInfo_ExcelSource and <PipelineComponentInfo_ExcelDestination> nodes by the following: