Monthly Archives: October 2012

SSIS Fuzzy Lookup Hangs

I ran into a problem where the Fuzzy Lookup transformation would hang when run from within BIDS. A command prompt window would open and close. It happened too fast to be able to read it. The lookup involved two relatively … Continue reading

Posted in SQL Server Integration Services | Tagged | 3 Comments

DQS Error DataServiceDataSourceTableNotFound

I ran across an error in the mapping in the Knowledge Discovery portion of DQS.  What appears to be a permissions issue is not.  In my case I had a geography column in a view.  It turns out this is … Continue reading

Posted in Data Quality Services | Tagged | Leave a comment

Data Visualization

Passing a long a good article from the MSDN Business Intelligence blog on best practices in data visualization. http://blogs.msdn.com/b/microsoft_business_intelligence1/archive/2012/10/08/best-practices-in-data-visualization.aspx

Posted in SQL Server Reporting Services | Tagged | Leave a comment

Self-Service Reporting in SQL 2012

With the demise of SSRS Report Models in 2012, I thought this article from Paul Turley was very timely. http://blogs.msdn.com/b/mvpawardprogram/archive/2012/09/24/the-state-of-self-service-reporting.aspx

Posted in SQL Server Reporting Services | Tagged , , | Leave a comment