2017 SSIS PackageFormatVersion?

Question

2017 SSIS PackageFormatVersion?

GeorgeCopeland

SSCertifiable

Points: 6997
More actions
January 25, 2019 at 2:32 pm

#381266

Would someone please look in a 2017 SSIS package and post the PackageFormatVersion value? I expect that it is 9 but I want to confirm. It is certainly missing from the doco.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Phil Parkin SSC Guru Points: 246937 More actions · Answer 1

GeorgeCopeland - Friday, January 25, 2019 2:32 PM
Would someone please look in a 2017 SSIS package and post the PackageFormatVersion value? I expect that it is 9 but I want to confirm. It is certainly missing from the doco.

I cannot see this property:

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

frederico_fonseca SSCoach Points: 16147 More actions · Answer 2

in the project file
<DtsPackage FormatVersion="8">
in the package itself
DTS:LastModifiedProductVersion="15.0.0900.40"
DTS:Name="PackageFormatVersion">8</DTS:Property>

this is with
Microsoft Visual Studio Professional 2017 Version 15.9.6
SQL Server Data Tools 15.1.61901.03220

GeorgeCopeland SSCertifiable Points: 6997 More actions · Answer 3

Phil Parkin - Saturday, January 26, 2019 7:06 PM
GeorgeCopeland - Friday, January 25, 2019 2:32 PM
Would someone please look in a 2017 SSIS package and post the PackageFormatVersion value? I expect that it is 9 but I want to confirm. It is certainly missing from the doco.
I cannot see this property:

Hi Phil, an SSIS package is an XML file. Package properties can be read by opening in a text editor.

GeorgeCopeland SSCertifiable Points: 6997 More actions · Answer 4

frederico_fonseca - Sunday, January 27, 2019 7:17 AM
in the project file
<DtsPackage FormatVersion="8">
in the package itself
DTS:LastModifiedProductVersion="15.0.0900.40"
DTS:Name="PackageFormatVersion">8</DTS:Property>
this is with
Microsoft Visual Studio Professional 2017 Version 15.9.6
SQL Server Data Tools 15.1.61901.03220

Hi Fredrico, thank you very kindly. PackageFormatVersion was 8 for SQL 2014, 2016 and now 2017.

Phil Parkin SSC Guru Points: 246937 More actions · Answer 5

GeorgeCopeland - Sunday, January 27, 2019 4:38 PM
Hi Phil, an SSIS package is an XML file. Package properties can be read by opening in a text editor.

Well, thanks a lot for the patronising reply.
Next time someone asks you to "look in a 2017 SSIS package", I assume that instead of firing up SSDT, you'll open it with an XML editor.

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

GeorgeCopeland SSCertifiable Points: 6997 More actions · Answer 6

Hi Phil, that reply was only patronizing in your own mind. I advise you not to take things so personally. Have a great day!