Why do i need to upgrade SSIS packages?

Question

It seems the backward compatibility of SSIS covered from SQL server 2008R2 to SQL server 2017 (since an instance with SQL server 2017 installed can proceed SSIS package with PackageFormatVersion = 3)

The question is why do we need to update the SSIS package (.dtsx)

Is there any performance boost or other necessaries by updating the SSIS package?

Answer 1

It is highly recommended to update packages because each new release of SQL Server contains new features, bug fixes, performance improvement. There are many articles describing the features of each release as example:

• in SQL Server 2016 package parts was founded which guarantee high re-usability
• ODATA components were added later than 2008 R2

You can refer to the following pages for more information:

• SQL Server Integration Services SSIS Versions and Tools
• Stackoverflow - SSIS tag info

Also not that the support of SQL Server 2008 R2 will end soon (July 9, 2019)