Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

SSIS Script Keeps Reverting To .Net Framework 4.5

Tags:

c#

.net

ssis

I've got the following issue: I've got an SSIS package, in which I would need to use some features of the .Net Framework 4.6.

Whenever I set the Framework version in the project proprties, it doesn't complain, I can build the project without errors. However, as soon as I save the file and close the script, it reverts to .Net 4.5.

I've checked these two links, but the solution did not work for me:

SSIS Script Component - Changing target .net version keeps reverting Cannot change Target Framework on Several Projects From v4.0 to V4.5 or 4.5.1

I've even installed the Target Framework Migration tool, which executes without errors, confirms that the framework was changed, but after closing and reopening the project it's back to v4.5 again.

Can anybody please help?

Thanks in advance.

like image 403
Gabor Avatar asked Mar 06 '23 12:03

Gabor


1 Answers

Approved answer will work for SQL Server 2016 and older versions.
Starting with SQL Server 2017 framework version is based on SSIS project target server version:

  • SQL Server 2017 enforces .Net framework 4.5
  • SQL Server 2019 enforces .Net framework 4.7
like image 119
Piotr Palka Avatar answered Mar 16 '23 01:03

Piotr Palka