Rapture in Everything

Posts tagged "programming"

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;...
tech programming msmq

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...
how-to programming tech

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...
programming fun .net

Scripted text processing

 When working on the last project at work, my tasks were often defined poorly. I had to make web services that would accept complicated data structures, but I only had one example file to go by. The file got updated from time to time, but never came as a valid XML – some can hardly be convinced you can’t just write strings instead of numbers or put a “-” anywhere in the file and expect it to be valid. So I had to process every file by hand. And by “hand”, I of course mean regexes or Python, just as...
how-to programming python

Debugging WCF service traffic with Fiddler

 At work, I had to look into request/response compression in WCF with .NET 3.5. In order to be sure whether what I’m doing had had the desired effect, I had to force Fiddler to capture the client-server SOAP traffic. So now I’ll try to summarize what I learned. The process consists of four steps: Hosting the web service Setting up Fiddler reverse proxy Modifying the WS’ WSDL file Setting up the client Calling the service via Fiddler’s proxy First, you need to host your service somewhere. In my example, I used the IIS 7.5...
programming how-to tech