September 6, 2012 at 11:41 pm
Hi all,
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[/url], 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.
November 2, 2012 at 10:38 am
Hi all,
Just wanted to follow up. After a bit of testing, my decompiler works great on my test package and actually provides a 10% performance boost compared to running SSIS directly when run on SQL 2008, since it makes use of table parameter inserts to speed up SSIS pipelines.
Anyways, I've posted the latest version here, maybe someone will find a use for it!
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply