|

Automate build and deployment of SSAS Cubes using MSBUILD

This post describes how to use MSBUILD to automate the build and deployment of a SSAS Analysis Services Cube. This solution relies on calling Visual Studio (devenv.exe) from within MSBUILD to first build the Cube and then using the SSAS deployment wizard from the command line to deploy the Cube. The first thing to understand…

| | |

Configuring SSIS Projects for Deployment : Quick Tip

When you build an SSIS Project, you can optionally also generate an SSIS deployment Utility. The Deployment Utility can be used to Deploy the SSIS Packages and Configuration Files on a Server. Below is an example SSIS Project configuration, which will trigger the generation of a Deployment Utility. In the image you can see that…

| | |

Understanding Visual Studio Solution Configuration Manager : Quick Tip

Understanding the Visual Studio Solution Configuration Manager Dialog. Below is an example screenshot of a Visual Studio Solution Configuration. This example shows a solution configuration called DEV. Within the project are two projects called Data_Integration and Data_Integration_Database. Associated with the DEV Solution configuration is the DEV Project Configuration of the Data_Integration and Data_Integration_Database projects. The…