We often get questions like, “How do I change the SSIS package version to match the SQL Server Version?” where you plan to deploy packages.
For example, if you are planning to Deploy SSIS Packages to SQL Server 2022, then it is better to design packages with the same Target Version.
Steps to change SSIS Target Version
-
Open SSIS Solution in Visual Studio (Assuming you have already installed SSIS Designer)
-
Right-click on SSIS Project Node > Click Properties
-
Go to Configurations and Change TargetServerVersion to match with your SQL Server
