Category: SQL

Running SSIS Packages with Python

Click here for a PDF version of this post. Microsoft's SSIS (SQL Server Integration Services) is a ubiquitous ETL (Extract Transform and Load) tool. Despite its widespread use, SSIS is not loved! At best, it's tolerated for its undeniable utility, but SSIS's “utility” comes with a host of hideous warts with the ugliest being its … Continue reading Running SSIS Packages with Python →

Extracting SQL code from SSIS dtsx packages with Python lxml

Click here for a PDF version of this post. Lately, I've been refactoring a sprawling SSIS (SQL Server Integration Services) package that ineffectually wrestles with large XML files. In this programmer's opinion using SSIS for heavy-duty XML parsing is geeky self-abuse so I've opted to replace an eye-ball straining1 SSIS package with half a dozen, … Continue reading Extracting SQL code from SSIS dtsx packages with Python lxml →

Common Table Expression (CTE) SQLServer Queries with J

I've been blogging long enough to observe that your awesome posts are often ignored while your little "one-offs" sometimes strike hit gold. This is particularly true for "code example" posts. When I'm trolling for code --- the geek equivalent of trolling for babes --- I don't want to read about the author's programming philosophy or what the hell … Continue reading Common Table Expression (CTE) SQLServer Queries with J →