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'
programming
Ruby on Bash on Windows
While in the process of migrating this blog
[https://zblesk.net/blog/yet-another-blog-migration/], I've made some modifications
[https://github.com/zblesk/scrawl] to the Scrawl theme by Kate Preston
[https://github.
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.
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’
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