SSIS package targeting SS 2019 enforces 4.7 but want to change it to 4.7.1 atleast across all SSIS packages

Question

SSIS package targeting SS 2019 enforces 4.7 but want to change it to 4.7.1 atleast across all SSIS packages

balu raju 56

It looks like SSIS packages targeting SS2019 enforces 4.7 .Net framework. However, I really want to enforce 4.7.1 or higher. I Can go and change at the script task level, but I guess that is not ideal if I have 40+ SSIS packages with 3 or more script tasks.

Is there a way to enforce the .Net framework for all SSIS Packages at once?

P.S. Since our services are all targeting 4.7.1 and some of the SSIS packages use those services, I Just want them all to be same.

1 answer

Your answer

Answer 1

Yitzhak Khabinsky 26,586

Hi @balu raju ,

It is possible.

SSIS packages are XML files with the extension *.dtsx
One single XML element controls what .Net Framework version is used by the Script Task.

So, you can use Notepad++ to make a change across multiple files on the file system

from <TargetFrameworkVersion>v4.7</TargetFrameworkVersion>
to <TargetFrameworkVersion>v4.7.1</TargetFrameworkVersion>

Just as a precaution, first copy *.dtsx packages on a side, or keep them under a Source Control.
So, if it will not work, you can easily recover working version of the packages.

P L 0 Reputation points

2023-07-06T19:29:38.1666667+00:00

While you can edit manually the dtsx, it has been found that since SSIS 2017, the targetframework is defined by the SQL Server Target version.

Target version 2017 = .net 4.5 forced

Target version 2019 = .net 4.7 forced

I tested targetting .net 4.8 using a target sql server 2017 that way, but it behaved like it was .net 4.5.

Have you been able to prove that it was really using .net 4.7.1 instead of 4.7?

(Thank you SSIS team for making this behavior and not documenting it...)

Share via

SSIS package targeting SS 2019 enforces 4.7 but want to change it to 4.7.1 atleast across all SSIS packages

1 answer

Your answer