SSIS - How to Find The Version Of SSIS Package From Dtsx File

Scenario: 

Let's say you just start working for a company and they pointed you to a folder which holds SSIS Packages. You need to find out the version of these SSIS Package and schedule them to SQL Server 2008 or SQL Server 2012 according to their version.

Solution:

To find out the version our SSIS Package , we need to read the .dtsx file itself. We can open the file by using different programs such as internet explorer or notepad or word pad etc. The .dtsx files are xml files and the property we need to look for is "PackageFormatVersion".

For SSIS 2008
PackageFormatVersion="PackageFormatVersion">3


For SSIS 2012 
PackageFormatVersion="PackageFormatVersion">6

Fig 1: SSIS Package with different versions

As you can see that I have two SSIS Packages but can't tell either they are SSIS 2008 or SSIS 2012.

Right Click on the Package.dtsx and go to Open With. You can choose the program you want to use for this. I opened it with Notepad.

Once the file is opened. You have to look for PackageFormatVersion. You can use Ctrl+F ( Find) and then find it. 

Fig 2: Find Version of SSIS Package from dtsx file

As PackageFormatVersion=6, This package was developed in SSIS 2012.


Let's check the package1.dtsx by using the same method.
Fig 3: Read SSIS Package file (dtsx) to find out version

As PackageFormatVersion=3, The version of this SSIS Package is 2008/2008 R2.

3 comments:

  1. How can I read the PackageFormatVersion property of an encrypted older SSIS package? Sure I can decrypt and open it in my VS but doing so the package gets upgraded in the process so that the value of the PackageFormatVersion property would no longer reflect the original value but instead the new value after the on-the-fly upgrade.

    ReplyDelete
  2. This is actually the kind of information I have been trying to find. Thank you for writing this information. csgo high tier accounts

    ReplyDelete
  3. PUBG Mobile is littered with vehicles, but most are abandoned and too damaged to be drivable. Learn the visual profiles of the drivable vehicles so you don't waste time. pubg mobile accounts

    ReplyDelete