Hi @Amit Trivedi,
The version of sql server is 2019 and when I deploy the package using both ways, I change the TargetServerVersion property to 2019.
You need to set TargetServerVersion property to SQL Server 2019 at the very beginning of the development in VS2019, not at the end, just before the deployment.
Please try to do deployment the following way:
- Using SSMS (It is better to use version 18 or 19) and connect to the SSIS run-time instance of SQL Server.
- Navigate to: "Integration [Services Catalogs] => ... => [Projects].
- Right mouse click, select [Deploy Project...].
- Select [Project deployment file], specify Path to the .ispac file, and follow the wizard.