A while back I started an experimental project to see if I could analyze the DTSX file format and decompile it into SQL statements. I thought doing so would help me understand how the SSIS packages I inherited work. Over the past few weeks I've spent a few minutes here and there patching the program and improving it, and I'd love to solicit your feedback and see if this kind of software is useful to anyone beside myself.
The program is available on code.google.com
, in source code
and in executable format
Given that I'm relatively new to SSIS - I used DTS a lot in the late '90s but haven't really touched it in a while - my primary goal with the project was to see if I could extract the SQL statements and use them to understand the code of the program in more detail. However I'm curious if this kind of a decompiler would be useful to others?
At the moment, the program is capable of decompiling my sample DTSX packages into a Visual Studio 2010 style solution file using C# as its programming language. It's capable of extracting embedded libraries, SQL statements, loops, variable dependence, and paths; but the program it produces isn't directly executable without some manual intervention. There are some issues with variable scoping, SQL statement parsing, and a few package components I have yet to parse.
That said, if anyone would like to provide feedback, I welcome your input.