Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Open source SSIS decompiler - work in progress Expand / Collapse
Author
Message
Posted Thursday, September 6, 2012 11:41 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, July 13, 2013 12:49 PM
Points: 9, Visits: 21
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, 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.
Post #1355752
Posted Friday, November 2, 2012 10:38 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, July 13, 2013 12:49 PM
Points: 9, Visits: 21
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!

http://code.google.com/p/csharp-dessist/downloads/list
Post #1380502
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse