After data is collected the following error occurs during the mapping stage:
Failed to load mapping destination elements. Check the Parameterize String is correct
This error occurs when the workstation on which the mapping is being done does not have the Microsoft Access Database Driver installed. Please use the following steps to resolve:
Check if the driver is installed
Go to Control Panel.
Administrative Tools.
ODBC Data Source Administrator (32-bit).
Drivers tab.
If no Microsoft Access Driver is installed
If no Microsoft Access Driver is installed, download the Microsoft Access Database Engine 2010 (32 bit).
Right click the Zip file, Properties, tick Unblock, Apply, OK.
Extract and run the Database Engine.
Restart APS.
Retry the Mmapping.
If there is Microsoft Access Database Engine 64bit installed
Use silent installation for 32 bit.
Cmd command: "C:\”FileLoaction”\AccessDatabaseEngine 32-bit.exe" /quiet
Once installed, restart APS.
Retry the mapping.