question

DavidDye-2330 avatar image
0 Votes"
DavidDye-2330 asked Monalv-msft edited

SSIS 2019 unable to create or save script task

I have upgraded to VS 2019 and trying to open existing projects or even trying to create a new project using a script task I am unable to save or compile it. The error shows that the binary code can not be found. When trying to build the script task I get an error "Severity Code Description Project File Line Suppression State Error Could not find a part of the path 'C:\Users######". This occurs for any task including for new projects when just creating an empty script using C#. Any help would be appreciated.

sql-server-integration-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

YitzhakKhabinsky-0887 avatar image
0 Votes"
YitzhakKhabinsky-0887 answered DavidDye-2330 commented

@DavidDye-2330,

If you are using VS2019, it was a bug introduced in the VS2019 v.16.9
You would need to install latest version of the SQL Server Integration Services Projects extension v.3.12.1 for VS2019.

The fix is documented here:

There is a regression in VS 2019 16.9 that will cause script task/component not work properly when editing script. VSTA team has released a new version to work around this issue. Please install latest version 3.12.1 to fix the issue, or you can keep on version 3.12 and manually download and install the latest version of VSTA 2019 here.

Here is the link: SQL Server Integration Services Projects


· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Worked. Thanks!!

0 Votes 0 ·
Monalv-msft avatar image
0 Votes"
Monalv-msft answered Monalv-msft edited

Hi @DavidDye-2330 ,

1.Could you please share the example code in the Script Task?
Please save the code in the Script Task and then delete the Script Task.
Please recreate new Script Task.

2.Please check if you set the TargetServerVersion as SQL Server 2019.

Best regards,
Mona


If the answer is helpful, please click "Accept Answer" and upvote it.

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.


· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @DavidDye-2330 ,

May I know if you have anything to update?

Best regards,
Mona

0 Votes 0 ·
DavidDye-2330 avatar image
0 Votes"
DavidDye-2330 answered

Thanks for the help. I am downloading the update to install and will let you know if this fixes the issue once I can complete.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.