Extracting SQL code from SSIS dtsx packages with Python lxml

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, "as simple as possible but no simpler", Python scripts. … Continue reading Extracting SQL code from SSIS dtsx packages with Python lxml

Cutting the Stinking Tauntaun and other Adventures in Software Archeology

The other day a software project that I had spent a year on was “put on the shelf.”  A year of effort was unceremoniously flushed down the software sewer.  A number of colleagues asked me, “How do you feel about this?” Would you believe relieved? This is not false bravado or stupid sunny optimism. I … Continue reading Cutting the Stinking Tauntaun and other Adventures in Software Archeology

WordPress to LaTeX with Pandoc and J: Using TeXfrWpxml.ijs (Part 3)

Click for an updated PDF version of this post. WordPress to LaTeX In this post I will describe how to use the J script TeXfrWpxml.ijs to generate LaTeX source from WordPress export XML.  I am assuming you have worked through (Part 1) and (Part 2) and have: Successfully installed and tested Pandoc.Installed and tested a … Continue reading WordPress to LaTeX with Pandoc and J: Using TeXfrWpxml.ijs (Part 3)

WordPress to LaTeX with Pandoc and J: LaTeX Directories (Part 2)

Click for an updated PDF version of this post. In this post I will describe the LaTeX directory structure the J script TeXfrWpxml.ijs is expecting. To convert WordPress export XML to LaTeX with this script you will have to set up similar directories. LaTeX documents are built from *.tex1 files. This makes LaTeX more like … Continue reading WordPress to LaTeX with Pandoc and J: LaTeX Directories (Part 2)