Monthly Archives: February 2015

Bike tour Business Intelligence: Part 3 [Reverse Geocoding]

In Part 2 I modified the SSIS data flow to add a column containing the position of each trackpoint read from the GPX file in the SQL Server spatial type geography . Part three investigates SQL spatial types further and … Continue reading

Posted in Spatial, SQL Server, SSIS | Tagged , , | 1 Comment

Bike Tour Business Intelligence: Part 2 [Geography]

My previous post covered using SSIS to read XML from a GPX file saving the data to a new table in a SQL Server Destination. This post will cover extending the SSIS workflow to create spatial data; the next on … Continue reading

Posted in Spatial, SQL Server, SSIS | Tagged , , , | 1 Comment

Bike Tour Business Intelligence: Part 1 [Reading GPX files with SSIS]

Last year I spent the summer riding my bike across Europe, clocking up 6100km through 7 different countries. Riding through the countryside with the wind blowing through your hair is a great feeling and I had a fantastic time. Now … Continue reading

Posted in SSIS | Tagged , | 1 Comment