Monthly Archives: November 2009

Presenting At SSIG in Greenville, SC

I’ll be doing a presentation on Analysis Services at the SQL Server Innovators Guild in Greenville, SC on Tuesday, Dec. 1st. I’ll be delivering an introduction to SSAS, with lots of demos. If you are interested in attending, please register … Continue reading

Posted in Uncategorized | Comments Off on Presenting At SSIG in Greenville, SC

SSIS 101: Viewing Variable Values at Runtime

One of the common problems that beginners have with SSIS is debugging errors involving variables. One example of this occurs when a package uses a Foreach Loop container. These are often used to set a variable value differently for each … Continue reading

Posted in Uncategorized | Comments Off on SSIS 101: Viewing Variable Values at Runtime

Using MSBuild with SQL Server Analysis Services Projects

I’ve written several blogs and community samples on working with SSAS Projects directly using AMO (instead of SSAS Databases on an Analysis Services server).  I was travelling this weekend, and got a chance to create a sample MSBuild task that … Continue reading

Posted in Uncategorized | Tagged , | Comments Off on Using MSBuild with SQL Server Analysis Services Projects

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 … Continue reading

Posted in Uncategorized | Tagged , | Comments Off on Validating SSAS Projects Programmatically