Rapture in Everything

Posts tagged "msmq"

Manipulate MSMQ with PowerShell

 I´ve recently published an open source MSMQ component for the SQL Server Integration Services. While working on its implementation (and other, related things), I’ve created some PowerShell utilities for queue manipulation. Now I’m consolidating them and putting them here, too. I’ts just a single ps1 file. Why? A valid question. After all, there already are PS cmdlets that do the same thing, and more. An advantage of this script is that while you have to install the MSMQ Cmdlets module, you only need to download the queue script and run it. (It doesn’t depend on...
tech scripting msmq

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