When setting up Continuous Integration in VSTS, chances are you’ll run into the problem of building SSIS projects: where database projects are building just fine, SSIS just doesn’t build out-of-the-box (at least not at the time of writing). Here’s how you fix it:
Continue reading...
Visual Studio
If you want to set up Continuous Integration using Visual Studio Team Services (VSTS) in order to build your BI projects, you'll run into the fact that some project types can be built and released out-of-the-box by MSBuild, while others need specific logic to create or deploy artifacts. In this post, I share my current
Continue reading...
Wait, didn't I post this already several weeks ago? Well, almost. A few weeks ago, I showed how to set up a build agent using devenv.com. Unfortunately, I ran into some problems like failing builds not reporting failure and SSAS Tabular projects not building correctly. However, it turns out to be pretty easy to build
Continue reading...
In my earlier post "Automated Deployments using Visual Studio" I metioned that the method described was a workaround because I hadn't figured out how to do a continuous build in VSTS (Visual Studio Team Services) yet. With hindsight, that workaround was not really needed: VSTS build turns out to be só easy, that it's ridiculous
Continue reading...
In my earlier post "Automated Testing for the Data Warehouse", I sketched the outlines of what would be needed in order to achieve automated testing for your Data Warehouse solutions. Today, I want to look at the first step: build & deploy. Between the previous post and the current one, some useful content about this has been written already
Continue reading...
Visual Studio's configuration manager is a beautiful thing to have. You set up your connection strings to dev, test and production (if applicable for a developer) and you can deploy easily to these environments. If you are not aware of this, try it out, it's a great feature.
Continue reading...
Yes, that typo was intended. Remember when I said this? [Using Google to find a solution to] Error messages? Be sure to include the exact message - "in quotes" Recently I encountered a occasion where this helped especially well. A colleague emailed me with the question why his VS2010 install didn't load his SSRS Preview correctly. The 'Run' functionality worked, but the
Continue reading...