Validating SSAS Projects Programmatically
Earlier this week I got a feature request from someone someone that was looking in to my SsasHelper sample on the Microsoft SQL Server Community Samples: Analysis Services site on CodePlex. She was interested in Building a SQL Server Analysis Services .ASDatabase file from a Visual Studio SSAS Project, but pointed out that I didn’t actually *validate* a project before creating the .ASDatabase file, so if someone had checked in a project with errors, the whole process could blow up (or we might deploy a database with some issues). I looked into doing this, and it turns out it’s really easy to accomplish. I updated the code in SsasHelper sample on CodePlex to show how to do this.