Rapture in Everything

Posts tagged "powershell"

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...
programming powershell cli

Manipulate MSMQ with PowerShell

 I´ve recently published an open source MSMQ component for the SQL Server Integration Services [https://zblesk.net/blog/2015/02/08/msmq-reader-component-for-ssis/]. 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 [https://github.com/zblesk/scripts/blob/master/queue.ps1]. Why? A valid question. After all, there already are [https://tech...
programming tech scripting