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.
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:
2.1m questions
2.1m answers
60 comments
57.0k users