Rapture in Everything

Posts tagged "programming"

Scripts for repeatable SSIS package deployment

Instead of writing manuals with a lot of pictures for a customer's admin, I prefer to write a script that does the deployment by itself when ran. Several times I'd needed to deploy SSIS packages and configure them with SQL scripts, which is a pain to do manually, since it involves a lot of clicking and SQL editing. Of course, another advantage of using scripts is that your deployments are repeatable, quick, and can be shared with your colleagues via your VCS of choice. All of the components used here should be present on any SQL server you are deploying...

csv-to-sqlite - copying from CSV files to a SQLite database

csv-to-sqlite is a command line tool that **takes CSV files and dumps their contents into a SQLite database**. The basic gist: for each file, the script creates a database table with the same name, tries to guess the data type, then copies all the data into the database....

MSMQ reader component for SSIS

Last year I had to use SQL Server Intergration Services package to read some data from a MSMQ queue and pump them into a database. It sounded easy enough, but I quickly ran into difficulties. While SSIS does provide some MSMQ reading/writing components, they seem to be primarily meant to facilitate communication between two SSIS packages – I hadn’t been able to make them just read the queue and dump the textual data. So I set out to implement my own component. It was a major pain, so I’m open sourcing it, in case someone else needs it;...

How to create a WCF web service from a WSDL

This wasn’t the first time I was tasked with creating a mock web service based on a WSDL file. I’ve tried multiple approaches, but most of them weren’t exactly what I needed. So after digging around a bit, I’ve found a way that suits me and does just that. I do not claim to be a WCF guru and there may be better ways to do this. If so, please let me know. But if you’re a developer in a hurry, you probably don’t care and have skipped these two paragraphs, anyway. :) Let’s...

Elemental words

“When I heard oxygen and magnesium hooked up, I was like OMg.” This joke more or less started it. We started exchanging similar ones with a friend and soon after I found myself wondering what fraction of the vocabulary is it possible to write using only the symbols of chemical elements. The thought nagged me until I gave in and started coding. Basically I was trying to convert as many words as possible into an alphabet consisting of these “letters”: So for example stab becomes STaB. There of course are many words where such transcription isn’t possible, and some...