Archive | Visual Studio

We Don’t Need No Duplication: Eliminating the Visual Studio “Do Not Ignore Duplicate Key errors” warning.

So when I open up a SQL Server Analysis Services Project in Visual Studio and it gives me the warning “Do not ignore duplicate key errors. Change the KeyDuplicate property of the error configuration so that it is not set to IgnoreError.” I thought to myself: “That’s a good idea.” I ought to do that. […]

Resolving Analysis Services “The provider ‘SQLNCLI.1’ is not registered”

I know. While everyone else is moving on to SQL 2012 here I am upgrading a SSAS 2005 cube to SQL Server 2008 R2 Analysis Services. I can hear Garth imploring me to “Live in the now man!” So as I went about the mundane task of upgrading a cube from a really old version […]