SSIS packages created using SQL Server (2005-2017) cannot be automatically upgraded to a later version without first performing a pre-upgrade step. First, open the .dtsx package file in a text editor such as Notepad. Next, replace all instances of 220.127.116.11 (if created using SQL Server 2005), 10.0.0.0 (2008), or 18.104.22.168 (2012), or 22.214.171.124 (2014) with either 10.0.0.0 (if upgrading to SQL Server 2008), 126.96.36.199 (2012), or 188.8.131.52 (2014), or 184.108.40.206 (2016), 220.127.116.11 (2017), 18.104.22.168 (2019) then save the modified file. Lastly, open the solution with BIDS (2008) or SQL Server Data Tools (2012/2017/2019), which will automatically convert the solution and package.
Note that as of SQL Server 2014-2019, SQL Server Data Tools must be downloaded and installed separately; please refer to: https://docs.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt?view=sql-server-ver15
If you experience an error related to tasks not being registered for use on the PC when attempting to open the tasks, please check that the TargetServerVersion in the SSIS package is set correctly relevant to the version of SQL Server you are using.
*2019 requires mSQL version 22.214.171.124 or newer
If you need to downgrade a project - then please click here