SQL Server Import & Export Wizard provider Error

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

Leave a Reply

Your email address will not be published. Required fields are marked *