SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Open source SSIS decompiler - work in progress


Open source SSIS decompiler - work in progress

Author
Message
ted 84432
ted 84432
SSC Rookie
SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)

Group: General Forum Members
Points: 29 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.
ted 84432
ted 84432
SSC Rookie
SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)

Group: General Forum Members
Points: 29 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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search