Welcome to ShenZhenJia Knowledge Sharing Community for programmer and developer-Open, Learning and Share
menu search
person
Welcome To Ask or Share your Answers For Others

Categories

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.

See Question&Answers more detail:os

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
thumb_up_alt 0 like thumb_down_alt 0 dislike
728 views
Welcome To Ask or Share your Answers For Others

1 Answer

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

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
thumb_up_alt 0 like thumb_down_alt 0 dislike
Welcome to ShenZhenJia Knowledge Sharing Community for programmer and developer-Open, Learning and Share
...