My application is currently using SSIS data packages (.Net Framework 4.5) in Visual Studio 2015, and the deployment target server version is SQL Server 2016.
I am planning to upgrade the application to .NET Framework 4.6.2 or a newer version (preferably on 4.8). what should i need to do?
Any help or link in this regard highly appriciated.
Tuhin PaulPosted Feb 19, 2023, 9:14 PM
Upgrading your application to .NET Framework 4.6.2 or a newer version can potentially cause compatibility issues with your existing SSIS data packages that are built with .NET Framework 4.5. It is important to test the data packages thoroughly after the upgrade to ensure that they work as expected.
You may need to follow the steps to upgrade your application:
1. Make a backup of your existing solution before upgrading.
2. Upgrade the solution to the new .NET Framework version by right-clicking on the project in Solution Explorer and selecting "Properties". In the "Application" tab, select the new version of the .NET Framework from the "Target framework" dropdown.
3. Update the SSIS data packages to the new .NET Framework version by opening the package in SQL Server Data Tools (SSDT) and rebuilding it with the new .NET Framework version.
4. Test the upgraded application and data packages thoroughly to ensure that they work as expected.
5. If you encounter any compatibility issues, you may need to modify the data packages or the application code to resolve them.
It is also important to note that the deployment target server version is SQL Server 2016, which may not be compatible with the latest .NET Framework versions. You may need to check the compatibility of the SQL Server version with the .NET Framework version that you are planning to use. You may need to update any third-party libraries or packages that are used in your application to ensure that they are compatible with the new .NET Framework version.
Muhammad Imran AnsariPosted Feb 19, 2023, 11:10 AM
Hi Rijwan - Yes, I have tried and installed .Net 4.8 but SSIS package on SQL Server 2016 failed and throwing initializing exception.
Rijwan AnsariPosted Feb 19, 2023, 8:41 AM
Hi,
You should be able to upgrade. Simply install .NET 4.8 framework and try to upgrade.
Jignesh KumarPosted Feb 19, 2023, 4:51 AM
https://learn.microsoft.com/en-us/answers/questions/578577/upgrading-to-net-framework-4-8-on-sql-server-2016
Fot .net framework,
https://learn.microsoft.com/en-us/dotnet/framework/migration-guide/
For SQL,
https://learn.microsoft.com/en-us/sql/sql-server/install/hardware-and-software-requirements-for-installing-sql-server?view=sql-server-ver15#hwswr