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

An introduction to integers and floating point numbers

Integers on a computer are simple and behave in predictable ways.  Floating point numbers are not and don’t always respectively –  I’ll explain what they are and why below.  Working with floating point numbers is also slightly like cleaning up after my dogs, which I will also explain below. Integers Integers are a bit like … Continue reading An introduction to integers and floating point numbers