Is it possible to Decompile and read an SSIS package code?

Question

I am working on a project which was owned by a different person. He created a job to update bunch of fields in handful of tables in SQL server. That job was based on an SSIS package. Now I have the DTSX file and the disabled job. When I tried to enable the job after changing the old credentials in the DTSX file, I am getting weird errors. I want to see the code behind the SSIS package and want to see how the update process is coded. Is there a way to do this?

Answer 1

I want to see the code behind the SSIS package and want to see how the update process is coded

As other answers mentioned, dtsx files are XML files, you can simply open these files using a text editor to check the code behind, or you can simply create a new Integration Services project using visual studio and add the package to check it's control flow.

• Integration Services (SSIS) Projects and Solutions

I added my own answer to list some of what i posted related to this issue, since it may give you some insights:

• Automate Version number Retrieval from .Dtsx files
• Reverse engineering SSIS package using C#
• Is there a way to save all queries present in a ssis package/dtsx file?
• Parse SSIS package
• Loading SSIS Package Programmatically in C#

Answer 2

DTSX files are just XML files. Just rename to xml, and open with an editor.

The query is a string that is built up via string concatenation.