While I was working with DQS, I got an error that didn’t allow me to export the cleansing results to an excel file. I searched to find that it was a known issue for the 64 bit version of Excel. So based on what I found, this is how I was able to solve the error:
1. Downloaded and Installed the SQL Server 2012 SP1
2. Ran the DQSInstaller.exe -upgrade command in the command prompt
That’s about it. And I was able to export the cleansing results to an 64 bit version of the excel file.
Screenshot 1:
Screenshot 2: