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.
- How I think of what is KnowledgeBase in SQL Server 2012 Data Quality Services (parasdoshi.com)
- SQL SERVER – Step by Step Guide to Beginning Data Quality Services in SQL Server 2012 – Introduction to DQS (sqlauthority.com)