Continuous Integration · Deployment · SQL Server · SSIS · Technology

Automate SSIS 2012 Project Deployment and Configuration Management using PowerShell – Part 2

Continuing Automate SSIS 2012 Project Deployment and Configuration Management using PowerShell – Part 1 Download SSISProject containing: DeploymentDemo SSIS Project SimpleSSISDeploy.ps1 Step 2: Add Parameters.xml to the SSIS Project Before SQL Server 2012, configuration data for SSIS package such as server names, database names, and SMTP servers can be stored in XML files, environment variables, or a separate configuration… Continue reading Automate SSIS 2012 Project Deployment and Configuration Management using PowerShell – Part 2

Automation · Continuous Integration · Deployment · SQL Server · SSIS · Technology

Automate SSIS 2012 Project Deployment and Configuration Management using PowerShell – Part 1

Let’s start this by describing the scenario with which the approach described below will be useful to you: You are using SQL Server 2012/2014 You have a separate server/instance for each staging environment (Development, Acceptance, Production, etc.) You would like to automate SSIS project deployments to your target environments You would like to automate managing SSIS package… Continue reading Automate SSIS 2012 Project Deployment and Configuration Management using PowerShell – Part 1

Automation · Continuous Integration · Deployment · SSAS

Deploy a SQL Server Analysis Services Project using PowerShell

Step 1: Build SQL Server Analysis Services solution using devenv /build, for example “<path>\devenv.com” AdventureWorksSSAS.sln /build Development In the bin folder of your solution, you should find <projName>.asdatabase, <projName>.deploymentoptions, <projName>.deploymenttargets and <projName>.configsettings XML files Step 2: Generate XMLA script using Microsoft.AnalysisServices.Deployment.exe Microsoft.AnalysisServices.Deployment.exe <path>\AdventureWorksSSAS.asdatabase /s:GenerateXmla.log /o:SSASDatabase.xmla Step 3. Execute XMLA on target server using PowerShell script. [System.Reflection.Assembly]::LoadWithPartialName(“Microsoft.AnalysisServices.AdomdClient”) # Read the target server from .deploymenttargets… Continue reading Deploy a SQL Server Analysis Services Project using PowerShell