change target framework to net 5 in ssis 2019 script task
I am trying to change the target framework for my SSIS 2019 script task to .NET 5.0 from .NET 4.7 by installing other frameworks. My changes are reverted back to .NET 4.7 once I save and close out from the script task. Could you please guide me on how to make my changes stick or the ideal way to switch the target framework to .NET 5.0
This is by design!
Since SSIS 2017, you are not able to change the script task/component's target framework since it is forced by the SSIS TargetServerVersion property. As mentioned in the following post, this is by design: Script Task Target Framework - Cannot Change or Save.
Later, In the SSIS extension version 3.2 preview, they mentioned that:
Upgraded .NET framework version to 4.7 for script task/component when the target server version is SQL Server 2019
This means that using SQL Server 2019 as TargetServerVersion will force .NET framework 4.7 as target framework for all script tasks/components.
You can check more information about SQL Server and required .NET framework versions in the following article:
- How to determine if a property is required?
- .NET 4.5 changing how Response.IsRequestBeingRedirected behaves on Ajax calls - why?
- CancellationToken with async Dapper methods?
- How to check if a number is a power of 2
- How to stop Visual Studio from adding IIS Express to launchsettings
- How do I create a generic converter for units of measurement in C#?
- WinUI 3 Community Toolkit: Undefined namespace XAML
- The constraint reference 'string' could not be resolved to a type. (netcoreapp3.0)
- "File Not Found" while trying to compile an RC file (probably dumb mistake)
- Using Snyk Build Task in Azure DevOps Pipeline Error for .Net 8 Project
- How to conditionally use the 'default' color in MAUI?
- Automatically Install Module/Extension in DNN (DotNetNuke)
- Can you explain difference between StrictMock and Partialmock?
- Stubbing a read only property with Rhino Mocks
- Retrieve the current view name in ASP.NET MVC?
- How to Use UnsafeAccessor to Check if Autofac.Core.Lifetime.LifetimeScope IsDisposed in .NET 8?
- How do I convert hexidecimal to decimal using C# & BigInt?
- How do I truncate a .NET string?
- KERNELBASE.dll Exception 0xe0434352 offset 0x000000000000a49d
- .NET MAUI Hybrid Blazor Copy to Clipboard
- How to bind the IsEnabled property to an OR of two values?
- error MSB3073: The command "npm install" exited with code 1
- CSharp Console - Account Login
- EF Core 9 .HasConversion
- How do strings work when shallow copying something in C#?
- How to set the target framework to v2.0 or v3.5 instead of 4.0 when compiling a program from a source file?
- How is it possible to see C# code after compilation/optimization?
- Start exe even with missing dependency dlls?
- Using Action(Of T...) over a custom delegate syntax for readability
- Is C# compiler not reporting all errors at once at each compile?