Automating the deployment of SSIS packages

Introduction This post describes how I have automated the deployment of SSIS packages to different environments (test, staging, production etc.)  There are definitely other ways of doing it, and some of these are possibly better - I think that this is the oldest-school way possible.  I will describe our context which I hope will explain … Continue reading Automating the deployment of SSIS packages

From Excel to SSIS, Part 4: Grouping and calculating

This article is part of a series: From Excel to SSIS Getting started File Save As (a kind of Hello, World! program for SSIS) Filtering rows Grouping and calculating Joining streams of data 0. Introduction Over the articles in the series, we have been gradually working our way towards useful and interesting SSIS code.  So far we … Continue reading From Excel to SSIS, Part 4: Grouping and calculating