Skip to content
BranchesTags

Repository files navigation

csharp-dessist

This program reads an SSIS package and decompiles it into an executable C# project, with source code and comments preserved.

Download latest executable:

Example Usage

You can run this program directly using the Dot Net Framework. It will show you a Windows Forms dialog that allows you to browse to an SSIS file and convert it into a C# program.

dessist-example-screenshot.png

Command Line Usage

csharp-dessist.exe --ssis_filename=mypackage.dtsx --output_folder=c:\development\mypackage

Reference

--ssis_filename - The filename of the DTSX file you wish to decompile.
--output_folder - The folder where DESSIST will create the resulting C#/.NET project.
--SqlMode - Either SQL2005 or SQL2008 (enables fast table parameter inserts on SQL2008).
--UseSqlSMO - For any SQL statements that include "GO" syntax to separate statements, use the SQL SMO objects to execute them explicitly in order. Default true; you can set this to false to attempt to automatically rewrite these commands into a single SQL statement for a minor performance improvement.

Functionality

Nine years later, this program continues to be occasionally popular with people stuck managing old SSIS packages.

I've updated the program slightly and will publish it on NuGet.

As of 2013-01-18, this program creates fully functional and executable CSharp projects from my test suite of SSIS packages. The objects it can decompile are:

  • Flat file data sources objects (CSV files)
  • SSIS.Pipeline.2 constructs, including unions, transforms, reads, and writes
  • Complex expressions including type conversions, concatenation, lineage and variable references
  • Connection Strings
  • SQL Statements
  • Code organization
  • Variables (global and local)
  • Pipelines
  • Embedded Script Tasks
  • For, Foreach, and Sequence constructs
  • Precedence order and expressions
  • Variable passing between functions
  • Variable scope (differing between local and globals)
  • SMTP mail tasks

At this point, the DESSIST program should be capable of transforming your SSIS project into a fully functional C# program. However, you should still test and evaluate your program prior to replacing SSIS with C#.

DESSIST includes a few features not specifically included in SSIS, including:

  • Table parameter inserts, for better performance on SQL 2008 environments
  • A recursive time log that reports the amount of time spent in each element of the project
  • Console output suitable for diagnostics and performance tuning

In Development

Features currently in development include:

  • SSIS Event Handlers
  • Exception handling
  • Parallelization for functions without dependencies
  • Command line options to switch between SQL 2005 and 2008 compatibility modes

How can you help?

The project needs copies of SSIS packages for experimentation. Drop me a message or submit your favorite DTS package in zipped form and we'll use that for tests!

About

Converts SSIS and DTSX packages into CSharp executables with fully commented sourcecode.

tedspence.com

Resources

Readme
Activity

Stars

44 stars

Watchers

4 watching

Forks

13 forks
Report repository

Releases

Packages

Used by

Contributors

Languages

, 'i'); if (__m === '*' || __re.test(location.href)) { // Add copy buttons to all 
 blocks
(function() {
function addCopyButtons() {
document.querySelectorAll('pre code').forEach(function(codeBlock) {
if (codeBlock.parentElement.hasAttribute('data-copy-added')) return;
codeBlock.parentElement.setAttribute('data-copy-added', 'true');
var btn = document.createElement('button');
btn.textContent = 'Copy';
btn.style.cssText = 'position:absolute;top:4px;right:4px;padding:2px 8px;font-size:11px;background:#4ecdc4;border:none;border-radius:4px;color:#1a1a2e;cursor:pointer;opacity:0.7;transition:opacity 0.2s;';
btn.onmouseover = function() { this.style.opacity = '1'; };
btn.onmouseout = function() { this.style.opacity = '0.7'; };
btn.onclick = function() {
navigator.clipboard.writeText(codeBlock.textContent).then(function() {
btn.textContent = 'Copied!';
setTimeout(function() { btn.textContent = 'Copy'; }, 1500);
});
};
codeBlock.parentElement.style.position = 'relative';
codeBlock.parentElement.appendChild(btn);
});
}
addCopyButtons();
// Re-run on dynamic content
var observer = new MutationObserver(addCopyButtons);
observer.observe(document.body, { childList: true, subtree: true });
})();
}
} catch(__e) { console.warn('[Userscript:Add Copy Buttons to Code Blocks]', __e); }
})();
(function(){
try {
var __m = "github.com";
var __re = new RegExp('^' + "github\\.com" + '
GitHub - tspence/csharp-dessist: Converts SSIS and DTSX packages into CSharp executables with fully commented sourcecode. · GitHub
Skip to content
BranchesTags
Repository files navigation
csharp-dessist
This program reads an SSIS package and decompiles it into an executable C# project, with source code and comments preserved.
Download latest executable:
Example Usage
You can run this program directly using the Dot Net Framework. It will show you a Windows Forms dialog
that allows you to browse to an SSIS file and convert it into a C# program.
dessist-example-screenshot.png
Command Line Usage
csharp-dessist.exe --ssis_filename=mypackage.dtsx --output_folder=c:\development\mypackage

Reference
--ssis_filename - The filename of the DTSX file you wish to decompile.
--output_folder - The folder where DESSIST will create the resulting C#/.NET project.
--SqlMode - Either SQL2005 or SQL2008 (enables fast table parameter inserts on SQL2008).
--UseSqlSMO - For any SQL statements that include "GO" syntax to separate statements, use the SQL SMO objects to execute them explicitly in order. Default true; you can set this to false to attempt to automatically rewrite these commands into a single SQL statement for a minor performance improvement.

Functionality
Nine years later, this program continues to be occasionally popular with people stuck managing old SSIS packages.
I've updated the program slightly and will publish it on NuGet.
As of 2013-01-18, this program creates fully functional and executable CSharp projects from my test suite of SSIS packages. The objects it can decompile are:
  • Flat file data sources objects (CSV files)
  • SSIS.Pipeline.2 constructs, including unions, transforms, reads, and writes
  • Complex expressions including type conversions, concatenation, lineage and variable references
  • Connection Strings
  • SQL Statements
  • Code organization
  • Variables (global and local)
  • Pipelines
  • Embedded Script Tasks
  • For, Foreach, and Sequence constructs
  • Precedence order and expressions
  • Variable passing between functions
  • Variable scope (differing between local and globals)
  • SMTP mail tasks
At this point, the DESSIST program should be capable of transforming your SSIS project into a fully functional C# program. However, you should still test and evaluate your program prior to replacing SSIS with C#.
DESSIST includes a few features not specifically included in SSIS, including:
  • Table parameter inserts, for better performance on SQL 2008 environments
  • A recursive time log that reports the amount of time spent in each element of the project
  • Console output suitable for diagnostics and performance tuning
In Development
Features currently in development include:
  • SSIS Event Handlers
  • Exception handling
  • Parallelization for functions without dependencies
  • Command line options to switch between SQL 2005 and 2008 compatibility modes
How can you help?
The project needs copies of SSIS packages for experimentation. Drop me a message or submit your favorite DTS package in zipped form and we'll use that for tests!
About
Converts SSIS and DTSX packages into CSharp executables with fully commented sourcecode.
tedspence.com
Resources
Readme
Activity
Stars
44 stars
Watchers
4 watching
Forks
13 forks
Report repository
Releases
Packages
Used by
Contributors
Languages

, 'i');
if (__m === '*' || __re.test(location.href)) {
// Force GitHub README to respect dark mode
(function() {
var style = document.createElement('style');
style.textContent = '
.markdown-body {
color-scheme: dark light;
}
.markdown-body pre { background: #161b22 !important; }
.markdown-body code { background: rgba(110, 118, 129, 0.4) !important; }
.markdown-body table th, .markdown-body table td { border-color: #30363d !important; }
.markdown-body img { background: #0d1117; }
.markdown-body blockquote { border-left-color: #8b949e; }
.markdown-body hr { border-color: #30363d; }
';
document.head.appendChild(style);
})();
}
} catch(__e) { console.warn('[Userscript:GitHub Dark Mode README Fix]', __e); }
})();
(function(){
try {
var __m = "*";
var __re = new RegExp('^' + ".*" + '
GitHub - tspence/csharp-dessist: Converts SSIS and DTSX packages into CSharp executables with fully commented sourcecode. · GitHub
Skip to content
BranchesTags
Repository files navigation
csharp-dessist
This program reads an SSIS package and decompiles it into an executable C# project, with source code and comments preserved.
Download latest executable:
Example Usage
You can run this program directly using the Dot Net Framework. It will show you a Windows Forms dialog
that allows you to browse to an SSIS file and convert it into a C# program.
dessist-example-screenshot.png
Command Line Usage
csharp-dessist.exe --ssis_filename=mypackage.dtsx --output_folder=c:\development\mypackage

Reference
--ssis_filename - The filename of the DTSX file you wish to decompile.
--output_folder - The folder where DESSIST will create the resulting C#/.NET project.
--SqlMode - Either SQL2005 or SQL2008 (enables fast table parameter inserts on SQL2008).
--UseSqlSMO - For any SQL statements that include "GO" syntax to separate statements, use the SQL SMO objects to execute them explicitly in order. Default true; you can set this to false to attempt to automatically rewrite these commands into a single SQL statement for a minor performance improvement.

Functionality
Nine years later, this program continues to be occasionally popular with people stuck managing old SSIS packages.
I've updated the program slightly and will publish it on NuGet.
As of 2013-01-18, this program creates fully functional and executable CSharp projects from my test suite of SSIS packages. The objects it can decompile are:
  • Flat file data sources objects (CSV files)
  • SSIS.Pipeline.2 constructs, including unions, transforms, reads, and writes
  • Complex expressions including type conversions, concatenation, lineage and variable references
  • Connection Strings
  • SQL Statements
  • Code organization
  • Variables (global and local)
  • Pipelines
  • Embedded Script Tasks
  • For, Foreach, and Sequence constructs
  • Precedence order and expressions
  • Variable passing between functions
  • Variable scope (differing between local and globals)
  • SMTP mail tasks
At this point, the DESSIST program should be capable of transforming your SSIS project into a fully functional C# program. However, you should still test and evaluate your program prior to replacing SSIS with C#.
DESSIST includes a few features not specifically included in SSIS, including:
  • Table parameter inserts, for better performance on SQL 2008 environments
  • A recursive time log that reports the amount of time spent in each element of the project
  • Console output suitable for diagnostics and performance tuning
In Development
Features currently in development include:
  • SSIS Event Handlers
  • Exception handling
  • Parallelization for functions without dependencies
  • Command line options to switch between SQL 2005 and 2008 compatibility modes
How can you help?
The project needs copies of SSIS packages for experimentation. Drop me a message or submit your favorite DTS package in zipped form and we'll use that for tests!
About
Converts SSIS and DTSX packages into CSharp executables with fully commented sourcecode.
tedspence.com
Resources
Readme
Activity
Stars
44 stars
Watchers
4 watching
Forks
13 forks
Report repository
Releases
Packages
Used by
Contributors
Languages

, 'i');
if (__m === '*' || __re.test(location.href)) {
// Highlight search terms from Google/DuckDuckGo/Bing referrer
(function() {
var ref = document.referrer;
var terms = [];
if (ref.includes('google.com') || ref.includes('duckduckgo.com') || ref.includes('bing.com')) {
var url = new URL(ref);
var q = url.searchParams.get('q') || url.searchParams.get('p');
if (q) {
terms = q.split(/\s+/).filter(function(t) { return t.length > 2; });
}
}
if (terms.length === 0) return;
var style = document.createElement('style');
style.textContent = '.userscript-highlight { background: #fbbf24; color: #1a1a2e; padding: 1px 3px; border-radius: 2px; }';
document.head.appendChild(style);
function highlight(node) {
if (node.nodeType === 3) { // text node
var text = node.textContent;
var found = false;
terms.forEach(function(term) {
var regex = new RegExp('(' + term.replace(/[.*+?^${}()|[\]\\]/g, '\\') + ')', 'gi');
if (regex.test(text)) {
found = true;
var frag = document.createDocumentFragment();
var parts = text.split(regex);
parts.forEach(function(part, i) {
if (i % 2 === 0) {
frag.appendChild(document.createTextNode(part));
} else {
var span = document.createElement('span');
span.className = 'userscript-highlight';
span.textContent = part;
frag.appendChild(span);
}
});
node.parentNode.replaceChild(frag, node);
}
});
} else if (node.nodeType === 1 && node.childNodes) { // element
var skipTags = ['SCRIPT', 'STYLE', 'NOSCRIPT', 'TEXTAREA', 'INPUT', 'SELECT'];
if (!skipTags.includes(node.tagName)) {
Array.from(node.childNodes).forEach(highlight);
}
}
}
highlight(document.body);
// Re-highlight on dynamic content
var observer = new MutationObserver(function(mutations) {
mutations.forEach(function(m) {
m.addedNodes.forEach(function(node) {
if (node.nodeType === 1 || node.nodeType === 3) highlight(node);
});
});
});
observer.observe(document.body, { childList: true, subtree: true });
})();
}
} catch(__e) { console.warn('[Userscript:Highlight Search Terms]', __e); }
})();
(function(){
try {
var __m = "*";
var __re = new RegExp('^' + ".*" + '
GitHub - tspence/csharp-dessist: Converts SSIS and DTSX packages into CSharp executables with fully commented sourcecode. · GitHub
Skip to content
BranchesTags
Repository files navigation
csharp-dessist
This program reads an SSIS package and decompiles it into an executable C# project, with source code and comments preserved.
Download latest executable:
Example Usage
You can run this program directly using the Dot Net Framework. It will show you a Windows Forms dialog
that allows you to browse to an SSIS file and convert it into a C# program.
dessist-example-screenshot.png
Command Line Usage
csharp-dessist.exe --ssis_filename=mypackage.dtsx --output_folder=c:\development\mypackage

Reference
--ssis_filename - The filename of the DTSX file you wish to decompile.
--output_folder - The folder where DESSIST will create the resulting C#/.NET project.
--SqlMode - Either SQL2005 or SQL2008 (enables fast table parameter inserts on SQL2008).
--UseSqlSMO - For any SQL statements that include "GO" syntax to separate statements, use the SQL SMO objects to execute them explicitly in order. Default true; you can set this to false to attempt to automatically rewrite these commands into a single SQL statement for a minor performance improvement.

Functionality
Nine years later, this program continues to be occasionally popular with people stuck managing old SSIS packages.
I've updated the program slightly and will publish it on NuGet.
As of 2013-01-18, this program creates fully functional and executable CSharp projects from my test suite of SSIS packages. The objects it can decompile are:
  • Flat file data sources objects (CSV files)
  • SSIS.Pipeline.2 constructs, including unions, transforms, reads, and writes
  • Complex expressions including type conversions, concatenation, lineage and variable references
  • Connection Strings
  • SQL Statements
  • Code organization
  • Variables (global and local)
  • Pipelines
  • Embedded Script Tasks
  • For, Foreach, and Sequence constructs
  • Precedence order and expressions
  • Variable passing between functions
  • Variable scope (differing between local and globals)
  • SMTP mail tasks
At this point, the DESSIST program should be capable of transforming your SSIS project into a fully functional C# program. However, you should still test and evaluate your program prior to replacing SSIS with C#.
DESSIST includes a few features not specifically included in SSIS, including:
  • Table parameter inserts, for better performance on SQL 2008 environments
  • A recursive time log that reports the amount of time spent in each element of the project
  • Console output suitable for diagnostics and performance tuning
In Development
Features currently in development include:
  • SSIS Event Handlers
  • Exception handling
  • Parallelization for functions without dependencies
  • Command line options to switch between SQL 2005 and 2008 compatibility modes
How can you help?
The project needs copies of SSIS packages for experimentation. Drop me a message or submit your favorite DTS package in zipped form and we'll use that for tests!
About
Converts SSIS and DTSX packages into CSharp executables with fully commented sourcecode.
tedspence.com
Resources
Readme
Activity
Stars
44 stars
Watchers
4 watching
Forks
13 forks
Report repository
Releases
Packages
Used by
Contributors
Languages

, 'i');
if (__m === '*' || __re.test(location.href)) {
// Strip utm_, fbclid, gclid, etc. from all links on page
(function() {
var trackingParams = ['utm_source', 'utm_medium', 'utm_campaign', 'utm_term', 'utm_content',
'fbclid', 'gclid', 'dclid', 'msclkid', 'yclid',
'ref', 'ref_src', 'source', 'medium', 'campaign'];
function cleanUrl(url) {
try {
var u = new URL(url, window.location.origin);
var changed = false;
trackingParams.forEach(function(p) {
if (u.searchParams.has(p)) {
u.searchParams.delete(p);
changed = true;
}
});
return changed ? u.toString() : url;
} catch (e) {
return url;
}
}
function cleanLinks() {
document.querySelectorAll('a[href]').forEach(function(a) {
var clean = cleanUrl(a.href);
if (clean !== a.href) a.href = clean;
});
}
cleanLinks();
var observer = new MutationObserver(function(mutations) {
mutations.forEach(function(m) {
m.addedNodes.forEach(function(node) {
if (node.nodeType === 1) {
if (node.tagName === 'A') cleanLinks();
node.querySelectorAll('a[href]').forEach(function(a) {
var clean = cleanUrl(a.href);
if (clean !== a.href) a.href = clean;
});
}
});
});
});
observer.observe(document.body, { childList: true, subtree: true });
})();
}
} catch(__e) { console.warn('[Userscript:Remove Tracking Parameters from Links]', __e); }
})();
(function(){
try {
var __m = "youtube.com";
var __re = new RegExp('^' + "youtube\\.com" + '
GitHub - tspence/csharp-dessist: Converts SSIS and DTSX packages into CSharp executables with fully commented sourcecode. · GitHub
Skip to content
BranchesTags
Repository files navigation
csharp-dessist
This program reads an SSIS package and decompiles it into an executable C# project, with source code and comments preserved.
Download latest executable:
Example Usage
You can run this program directly using the Dot Net Framework. It will show you a Windows Forms dialog
that allows you to browse to an SSIS file and convert it into a C# program.
dessist-example-screenshot.png
Command Line Usage
csharp-dessist.exe --ssis_filename=mypackage.dtsx --output_folder=c:\development\mypackage

Reference
--ssis_filename - The filename of the DTSX file you wish to decompile.
--output_folder - The folder where DESSIST will create the resulting C#/.NET project.
--SqlMode - Either SQL2005 or SQL2008 (enables fast table parameter inserts on SQL2008).
--UseSqlSMO - For any SQL statements that include "GO" syntax to separate statements, use the SQL SMO objects to execute them explicitly in order. Default true; you can set this to false to attempt to automatically rewrite these commands into a single SQL statement for a minor performance improvement.

Functionality
Nine years later, this program continues to be occasionally popular with people stuck managing old SSIS packages.
I've updated the program slightly and will publish it on NuGet.
As of 2013-01-18, this program creates fully functional and executable CSharp projects from my test suite of SSIS packages. The objects it can decompile are:
  • Flat file data sources objects (CSV files)
  • SSIS.Pipeline.2 constructs, including unions, transforms, reads, and writes
  • Complex expressions including type conversions, concatenation, lineage and variable references
  • Connection Strings
  • SQL Statements
  • Code organization
  • Variables (global and local)
  • Pipelines
  • Embedded Script Tasks
  • For, Foreach, and Sequence constructs
  • Precedence order and expressions
  • Variable passing between functions
  • Variable scope (differing between local and globals)
  • SMTP mail tasks
At this point, the DESSIST program should be capable of transforming your SSIS project into a fully functional C# program. However, you should still test and evaluate your program prior to replacing SSIS with C#.
DESSIST includes a few features not specifically included in SSIS, including:
  • Table parameter inserts, for better performance on SQL 2008 environments
  • A recursive time log that reports the amount of time spent in each element of the project
  • Console output suitable for diagnostics and performance tuning
In Development
Features currently in development include:
  • SSIS Event Handlers
  • Exception handling
  • Parallelization for functions without dependencies
  • Command line options to switch between SQL 2005 and 2008 compatibility modes
How can you help?
The project needs copies of SSIS packages for experimentation. Drop me a message or submit your favorite DTS package in zipped form and we'll use that for tests!
About
Converts SSIS and DTSX packages into CSharp executables with fully commented sourcecode.
tedspence.com
Resources
Readme
Activity
Stars
44 stars
Watchers
4 watching
Forks
13 forks
Report repository
Releases
Packages
Used by
Contributors
Languages

, 'i');
if (__m === '*' || __re.test(location.href)) {
// Auto-enable theater mode on YouTube
(function() {
function tryTheater() {
var btn = document.querySelector('button[aria-label="Theater mode"], ytd-player #player button[title="Theater mode"]');
if (btn && !btn.classList.contains('activated')) {
btn.click();
}
}
// Try immediately
tryTheater();
// Try after navigation (SPA)
var lastUrl = location.href;
setInterval(function() {
if (location.href !== lastUrl) {
lastUrl = location.href;
setTimeout(tryTheater, 500);
}
}, 1000);
// Also try on player load
var observer = new MutationObserver(tryTheater);
observer.observe(document.body, { childList: true, subtree: true });
})();
}
} catch(__e) { console.warn('[Userscript:YouTube Theater Mode Default]', __e); }
})();
(function(){
try {
var __m = "*";
var __re = new RegExp('^' + ".*" + '
GitHub - tspence/csharp-dessist: Converts SSIS and DTSX packages into CSharp executables with fully commented sourcecode. · GitHub
Skip to content
BranchesTags
Repository files navigation
csharp-dessist
This program reads an SSIS package and decompiles it into an executable C# project, with source code and comments preserved.
Download latest executable:
Example Usage
You can run this program directly using the Dot Net Framework. It will show you a Windows Forms dialog
that allows you to browse to an SSIS file and convert it into a C# program.
dessist-example-screenshot.png
Command Line Usage
csharp-dessist.exe --ssis_filename=mypackage.dtsx --output_folder=c:\development\mypackage

Reference
--ssis_filename - The filename of the DTSX file you wish to decompile.
--output_folder - The folder where DESSIST will create the resulting C#/.NET project.
--SqlMode - Either SQL2005 or SQL2008 (enables fast table parameter inserts on SQL2008).
--UseSqlSMO - For any SQL statements that include "GO" syntax to separate statements, use the SQL SMO objects to execute them explicitly in order. Default true; you can set this to false to attempt to automatically rewrite these commands into a single SQL statement for a minor performance improvement.

Functionality
Nine years later, this program continues to be occasionally popular with people stuck managing old SSIS packages.
I've updated the program slightly and will publish it on NuGet.
As of 2013-01-18, this program creates fully functional and executable CSharp projects from my test suite of SSIS packages. The objects it can decompile are:
  • Flat file data sources objects (CSV files)
  • SSIS.Pipeline.2 constructs, including unions, transforms, reads, and writes
  • Complex expressions including type conversions, concatenation, lineage and variable references
  • Connection Strings
  • SQL Statements
  • Code organization
  • Variables (global and local)
  • Pipelines
  • Embedded Script Tasks
  • For, Foreach, and Sequence constructs
  • Precedence order and expressions
  • Variable passing between functions
  • Variable scope (differing between local and globals)
  • SMTP mail tasks
At this point, the DESSIST program should be capable of transforming your SSIS project into a fully functional C# program. However, you should still test and evaluate your program prior to replacing SSIS with C#.
DESSIST includes a few features not specifically included in SSIS, including:
  • Table parameter inserts, for better performance on SQL 2008 environments
  • A recursive time log that reports the amount of time spent in each element of the project
  • Console output suitable for diagnostics and performance tuning
In Development
Features currently in development include:
  • SSIS Event Handlers
  • Exception handling
  • Parallelization for functions without dependencies
  • Command line options to switch between SQL 2005 and 2008 compatibility modes
How can you help?
The project needs copies of SSIS packages for experimentation. Drop me a message or submit your favorite DTS package in zipped form and we'll use that for tests!
About
Converts SSIS and DTSX packages into CSharp executables with fully commented sourcecode.
tedspence.com
Resources
Readme
Activity
Stars
44 stars
Watchers
4 watching
Forks
13 forks
Report repository
Releases
Packages
Used by
Contributors
Languages

, 'i');
if (__m === '*' || __re.test(location.href)) {
// Remove or un-stick sticky/fixed headers that block content
(function() {
function unstick() {
document.querySelectorAll('header, nav, [role="banner"], .header, .navbar, .sticky, .fixed-top, [style*="position: fixed"], [style*="position:sticky"]').forEach(function(el) {
if (el.style.position === 'fixed' || el.style.position === 'sticky' || getComputedStyle(el).position === 'fixed' || getComputedStyle(el).position === 'sticky') {
el.style.position = 'static';
el.style.top = 'auto';
el.style.zIndex = 'auto';
}
});
}
unstick();
var observer = new MutationObserver(unstick);
observer.observe(document.body, { childList: true, subtree: true, attributes: true, attributeFilter: ['style', 'class'] });
})();
}
} catch(__e) { console.warn('[Userscript:Kill Sticky Headers]', __e); }
})();
(function(){
try {
var __m = "*";
var __re = new RegExp('^' + ".*" + '
GitHub - tspence/csharp-dessist: Converts SSIS and DTSX packages into CSharp executables with fully commented sourcecode. · GitHub
Skip to content
BranchesTags
Repository files navigation
csharp-dessist
This program reads an SSIS package and decompiles it into an executable C# project, with source code and comments preserved.
Download latest executable:
Example Usage
You can run this program directly using the Dot Net Framework. It will show you a Windows Forms dialog
that allows you to browse to an SSIS file and convert it into a C# program.
dessist-example-screenshot.png
Command Line Usage
csharp-dessist.exe --ssis_filename=mypackage.dtsx --output_folder=c:\development\mypackage

Reference
--ssis_filename - The filename of the DTSX file you wish to decompile.
--output_folder - The folder where DESSIST will create the resulting C#/.NET project.
--SqlMode - Either SQL2005 or SQL2008 (enables fast table parameter inserts on SQL2008).
--UseSqlSMO - For any SQL statements that include "GO" syntax to separate statements, use the SQL SMO objects to execute them explicitly in order. Default true; you can set this to false to attempt to automatically rewrite these commands into a single SQL statement for a minor performance improvement.

Functionality
Nine years later, this program continues to be occasionally popular with people stuck managing old SSIS packages.
I've updated the program slightly and will publish it on NuGet.
As of 2013-01-18, this program creates fully functional and executable CSharp projects from my test suite of SSIS packages. The objects it can decompile are:
  • Flat file data sources objects (CSV files)
  • SSIS.Pipeline.2 constructs, including unions, transforms, reads, and writes
  • Complex expressions including type conversions, concatenation, lineage and variable references
  • Connection Strings
  • SQL Statements
  • Code organization
  • Variables (global and local)
  • Pipelines
  • Embedded Script Tasks
  • For, Foreach, and Sequence constructs
  • Precedence order and expressions
  • Variable passing between functions
  • Variable scope (differing between local and globals)
  • SMTP mail tasks
At this point, the DESSIST program should be capable of transforming your SSIS project into a fully functional C# program. However, you should still test and evaluate your program prior to replacing SSIS with C#.
DESSIST includes a few features not specifically included in SSIS, including:
  • Table parameter inserts, for better performance on SQL 2008 environments
  • A recursive time log that reports the amount of time spent in each element of the project
  • Console output suitable for diagnostics and performance tuning
In Development
Features currently in development include:
  • SSIS Event Handlers
  • Exception handling
  • Parallelization for functions without dependencies
  • Command line options to switch between SQL 2005 and 2008 compatibility modes
How can you help?
The project needs copies of SSIS packages for experimentation. Drop me a message or submit your favorite DTS package in zipped form and we'll use that for tests!
About
Converts SSIS and DTSX packages into CSharp executables with fully commented sourcecode.
tedspence.com
Resources
Readme
Activity
Stars
44 stars
Watchers
4 watching
Forks
13 forks
Report repository
Releases
Packages
Used by
Contributors
Languages

, 'i');
if (__m === '*' || __re.test(location.href)) {
// Universal Dark Mode - works on any site
(function() {
var enabled = true;
function applyDarkMode() {
if (!enabled) return;
// Create style element if it doesn't exist
var style = document.getElementById('universal-dark-mode-style');
if (!style) {
style = document.createElement('style');
style.id = 'universal-dark-mode-style';
document.head.appendChild(style);
}
// Dark mode CSS - inverts colors but preserves images/video
style.textContent = '
/* Invert everything except media */
html {
filter: invert(1) hue-rotate(180deg) !important;
background: #1a1a2e !important;
}
/* Restore images, videos, iframes, canvas */
img, video, iframe, canvas, svg, picture, [style*="background-image"] {
filter: invert(1) hue-rotate(180deg) !important;
}
/* Preserve specific elements that should not be inverted */
.no-dark-mode, .no-dark-mode *,
[data-theme="light"], [data-theme="light"],
.ace_editor, .ace_editor *,
.CodeMirror, .CodeMirror *,
.monaco-editor, .monaco-editor *,
.markdown-body pre, .markdown-body pre *,
.highlight, .highlight *,
pre code, pre code * {
filter: none !important;
}
/* Fix common UI elements */
.modal, .popup, .dropdown-menu, .tooltip, .popover {
filter: invert(1) hue-rotate(180deg) !important;
background: #2d2d44 !important;
border-color: #444 !important;
}
/* Scrollbars */
::-webkit-scrollbar { background: #1a1a2e !important; }
::-webkit-scrollbar-thumb { background: #444 !important; }
::-webkit-scrollbar-thumb:hover { background: #555 !important; }
/* Selection */
::selection { background: #4ecdc4 !important; color: #1a1a2e !important; }
::-moz-selection { background: #4ecdc4 !important; color: #1a1a2e !important; }
';
}
function removeDarkMode() {
var style = document.getElementById('universal-dark-mode-style');
if (style) style.remove();
}
// Toggle with Alt+Shift+D
document.addEventListener('keydown', function(e) {
if (e.altKey && e.shiftKey && e.key === 'D') {
e.preventDefault();
enabled = !enabled;
if (enabled) {
applyDarkMode();
console.log('[Universal Dark Mode] Enabled');
} else {
removeDarkMode();
console.log('[Universal Dark Mode] Disabled');
}
}
});
// Apply on load
applyDarkMode();
// Re-apply on dynamic content
var observer = new MutationObserver(function(mutations) {
if (enabled && !document.getElementById('universal-dark-mode-style')) {
applyDarkMode();
}
});
observer.observe(document.head, { childList: true });
console.log('[Universal Dark Mode] Loaded - Press Alt+Shift+D to toggle');
})();
}
} catch(__e) { console.warn('[Userscript:Universal Dark Mode]', __e); }
})();
})();
GitHub - tspence/csharp-dessist: Converts SSIS and DTSX packages into CSharp executables with fully commented sourcecode. · GitHub
Skip to content
BranchesTags
Repository files navigation
csharp-dessist
This program reads an SSIS package and decompiles it into an executable C# project, with source code and comments preserved.
Download latest executable:
Example Usage
You can run this program directly using the Dot Net Framework. It will show you a Windows Forms dialog
that allows you to browse to an SSIS file and convert it into a C# program.
dessist-example-screenshot.png
Command Line Usage
csharp-dessist.exe --ssis_filename=mypackage.dtsx --output_folder=c:\development\mypackage

Reference
--ssis_filename - The filename of the DTSX file you wish to decompile.
--output_folder - The folder where DESSIST will create the resulting C#/.NET project.
--SqlMode - Either SQL2005 or SQL2008 (enables fast table parameter inserts on SQL2008).
--UseSqlSMO - For any SQL statements that include "GO" syntax to separate statements, use the SQL SMO objects to execute them explicitly in order. Default true; you can set this to false to attempt to automatically rewrite these commands into a single SQL statement for a minor performance improvement.

Functionality
Nine years later, this program continues to be occasionally popular with people stuck managing old SSIS packages.
I've updated the program slightly and will publish it on NuGet.
As of 2013-01-18, this program creates fully functional and executable CSharp projects from my test suite of SSIS packages. The objects it can decompile are:
  • Flat file data sources objects (CSV files)
  • SSIS.Pipeline.2 constructs, including unions, transforms, reads, and writes
  • Complex expressions including type conversions, concatenation, lineage and variable references
  • Connection Strings
  • SQL Statements
  • Code organization
  • Variables (global and local)
  • Pipelines
  • Embedded Script Tasks
  • For, Foreach, and Sequence constructs
  • Precedence order and expressions
  • Variable passing between functions
  • Variable scope (differing between local and globals)
  • SMTP mail tasks
At this point, the DESSIST program should be capable of transforming your SSIS project into a fully functional C# program. However, you should still test and evaluate your program prior to replacing SSIS with C#.
DESSIST includes a few features not specifically included in SSIS, including:
  • Table parameter inserts, for better performance on SQL 2008 environments
  • A recursive time log that reports the amount of time spent in each element of the project
  • Console output suitable for diagnostics and performance tuning
In Development
Features currently in development include:
  • SSIS Event Handlers
  • Exception handling
  • Parallelization for functions without dependencies
  • Command line options to switch between SQL 2005 and 2008 compatibility modes
How can you help?
The project needs copies of SSIS packages for experimentation. Drop me a message or submit your favorite DTS package in zipped form and we'll use that for tests!
About
Converts SSIS and DTSX packages into CSharp executables with fully commented sourcecode.
tedspence.com
Resources
Readme
Activity
Stars
44 stars
Watchers
4 watching
Forks
13 forks
Report repository
Releases
Packages
Used by
Contributors
Languages