KK4CUH's blog

Wanted to create a single band Raspberry Pi SUPER QRP transmitter.

Bought and built one of these: https://shop.languagespy.com/collections/frontpage/products/pi-lpf-low-p...

Installed it on a R-Pi 3 i had sitting around from adafruit.

Using Jessie Lite as an OS on the RPi i used this software: https://github.com/JamesP6000/WsprryPi

Found this site had an archive of historical WSPR data going back to 2008 in CSV format. Since i'm a DBA with backup skill set in BI i wanted to load all historical data into a SQL Server database.

Needed a way to automate download .zip files and found a version of wget that works on Windows.

By using SQL Server Integration Service I created a process to download the current and 23 previous months of .zip files from site, perform an extract and load the CSV data into a table.