December 26, 2019 at 2:45 pm
Would someone please look in a 2019 SSIS package for the value of PackageFormatVersion? This value has been 8 since SQL Server 2014. This matters because knowing it could help in decisions to upgrade.
December 27, 2019 at 3:10 pm
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
December 30, 2019 at 3:44 pm
Hey George,
The PackageFormatVersion is still 8 with a TargetServerVersion of SQL Server 2019. It was previously 6 with SQL Server 2012, but has not changed since.
With the newest Integration Services Version 3.3 installation, something else from the notes peaked my interest:
SQL Server Native Client (SQLNCLI11.1) is deprecated and not installed by VS2019. We recommend upgrading to the new Microsoft OLE DB driver for SQL Server. If you want to continue using SQL Server Native Client, you can download and install it from here.
This may also be an important factor to consider with upgrading.
December 30, 2019 at 6:42 pm
PackageFormatVersion is still 8, thank you very kindly. I agree that deprecation of the native client is interesting. For production applications, I recommend of course complying with the recommended upgrade. Where this can be an issue is distributing client software. For some applications, it may make sense to continue to use the native client, considering that it may already be installed on user workstations.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply