Automation · Continuous Integration · SQL Server · SSIS · Technology

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

Continuing: Automate SSIS 2012 Project Deployment and Configuration Management using PowerShell – Part 2 Download SSISProject containing: DeploymentDemo SSIS Project SimpleSSISDeploy.ps1 Step 3: Execute SimpleSSISDeploy.ps1 Last and definitely NOT the least, where all the magic happens – SimpleSSISDeploy.ps1. I put comments where needed, and you can download a zip of all the components, as well as a sample… Continue reading Automate SSIS 2012 Project Deployment and Configuration Management using PowerShell – Part 3

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

Others · Technology

Human-Centered Design and The Wallet Project

What comes to your mind when you hear the word design? Color, shape, packaging? In many industries, design is often misinterpreted as the visual layer of a product. The fact that aesthetics is the most obvious aspect end-users see in a product is perhaps the reason why product teams give it more attention. Indeed, how something looks… Continue reading Human-Centered Design and The Wallet Project