Error : SSMS DTS Wizard throw error
The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine. (System.Data)
TITLE: SQL Server Import and Export Wizard ------------------------------ The operation could not be completed. ------------------------------ ADDITIONAL INFORMATION: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. (System.Data)
The error is due to SSMS calling 32-bit DTSWizard.
To Resolve the error
1.Copy 64-bit DTSWizard.exe from location C:\Program Files\Microsoft SQL Server\140\DTS\Binn and replace the file at location C:\Program Files (x86)\Microsoft SQL Server\140\DTS\Binn
2. Now try calling the DTSWizard from SSMS