SSIS 2019 unable to create or save script task

Question

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.

Answer 1

@David Dye ,

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

Answer 2

Hi @David Dye ,

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.

Answer 3

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.