Home
About
SK blog
Rapture in Everything
Posts tagged "msmq"
2015 Feb 12
2015 Feb 12
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
2015 Feb 09
2015 Feb 09
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