Visual Studio SSIS project execute script task : C# version

Question

Visual Studio SSIS project execute script task : C# version

sakuraime 2,341

I have a SSIS project and there is a script task inside it . but i am wonder if I can change the C# project version of it ? it always keep at framework 4.5

2 answers

Your answer

Answer 1

ZoeHui-MSFT 41,491

Hi @sakuraime ,

You could change the version of it.

It will pop up a window for more details.

You may have a try.

Regards，

Zoe

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

sakuraime 2,341 Reputation points

2021-12-22T15:16:41.023+00:00

if the SSIS project version is kept at sql server 2017 , all the VB script task will also stick to .net 4.5

while in sql server 2019 ssis project version all the VB script task will stick to .net 4.7.

you can have a test.it can't be change unless the ssis project version change .

Answer 2

Yitzhak Khabinsky 26,586

Hi @sakuraime ,

It is a bug in the Visual Studio (VS). It does allow to change a .Net Framework.
Though if you re-open it again, it will show you old value.

Don't believe your eyes, the UI is deceiving.
SSIS package 'remembers' that setting correctly.
You can easily check it by viewing inside the SSIS package itself. After all, it is an XML file.
Look for the following tag:

<TargetFrameworkVersion>v4.7.2</TargetFrameworkVersion>

sakuraime 2,341 Reputation points

2021-12-23T13:29:45.517+00:00

so how to change it ?
Yitzhak Khabinsky 26,586 Reputation points

2021-12-23T16:04:10.497+00:00
@sakuraime ,

Steps:

Change TargetFramework in the Visual Studio (VS) GUI.

Check the TargetFrameworkVersion tag inside the SSIS package.

Ignore what the TargetFramework in the Visual Studio (VS) GUI shows. It is a GUI bug.
P L 0 Reputation points

2023-07-06T19:26:09.96+00:00

Not sure it is a bug, while we can update the target version even manually in the dtsx, SSIS 2017 will use .net 4.5 as the target framework for the embedded VSTA project.

To use .net 4.7, the target server version would need to be SQL 2019.

Since SSIS 2017, the script task target framework is forced by SSIS.

This is poorly documented, but quoted at multiple places and I confirm the same behavior on my end.

Share via

Visual Studio SSIS project execute script task : C# version

2 answers

Your answer