VSTA 2019 - Unable to build script task

Alex Kisiel 76

Hi, I've recently been setting up a new machine, and after setting up VS2019, along with the SSIS Package extension, I am now unable to build SSIS Script Tasks from previously-existing packages. I also had to install VSTA 2019 separately, as that wasn't added by the SSIS extension.

When attempting to build mscorlib throws the following error:

Could not find part of path 'C:\Users\akisiel\AppData\Local\Temp\vsta\22a6604e4a064cbeaf73a4fe72e33158_out'

I'm unable to find any information about this error, and have tried repairing and even reinstalling the following:

VS 2019 SQL Projects
V2 2019 itself
SSIS Packages for VS2019 extension.

Has anybody experienced this previously and able to help?

Thanks,

Myers,Brennan 116 Reputation points

2021-03-07T19:56:42.007+00:00

I'm experiencing the same issue (although I'll note - mine is not just with previously-existing packages, but any Script Task package).

If you've searched around a bit, you'll find suggestions to delete your .suo, close the solution, re-open + rebuild - that didn't work for me.
I also found suggestions to simply create the folder contained in the first section of the error ("..._out") - I created ~20 folders before I gave up. It would simply tell me a new folder name was not found each time.

I've done the following, as well:

Re-installed VS2019 Enterprise
Ensured I had the SSIS Projects Extension in nuget, removed it + re-added
Ensured I could connect to my SQL Server where SSIS is running via SSMS

If I find the fix, I'll make sure to come back and share!
Amruta Raul 11 Reputation points

2021-04-06T09:41:30.797+00:00

I could resolve this issue by using the latest fix of VSTA.

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.

https://www.microsoft.com/en-us/download/details.aspx?id=58317
Jonathan Ordoñez 1 Reputation point

2021-04-16T17:30:33.817+00:00

It just works so we should upvote it
Piquet@DWS 1 Reputation point

2021-06-04T00:04:35.073+00:00

VS2019 fix: Downloading VSTA 2019 from AmrutaR-4991's link & attempting to install it brought up the "Repair" dialog (i.e. VSTA 2019 was already installed). Selecting to Repair VSTA 2019 resolved the Edit Script issue in VS2019 SSIS projects. I don't know if the repair included a download of the latest version of VSTA (I suspect it did), but at least I am now once again productive.
VS2019 Help About doesn't show a version number for VSTA (only a GUID) - had to go to control panel, which shows the VSTA 2019 version (after the Repair) as 16.0.31110 - which suggests it's version 3.11.10? (and not 3.12.1?). Regardless, I'm now once more able to edit script transform in SSIS.

Accepted answer

Myers,Brennan 116 Reputation points

2021-03-07T20:12:57.317+00:00

Update: reverting my VS2019 v16.9 install to v16.7 fixed the issue.
Just noticed this note: https://marketplace.visualstudio.com/items?itemName=SSIS.SqlServerIntegrationServicesProjects

Common Issues
There is a regression in VS 2019 16.9 that will cause script task/component not work properly when editing script. Please do NOT upgrade to 16.9 currently. If you have already upgraded to 16.9, please rollback to 16.8 or earlier version if you are using script task/component. VS team is working on the fix. Sorry for any inconvenience.

I'm uninstalling v16.9 right now, then installing v16.7 (v16.8 isn't available in my VSS list).
Will report back.
Please sign in to rate this answer.

7 people found this answer helpful.
Wichie Artu 6 Reputation points

2021-03-09T17:11:56.03+00:00

I rolled back to 16.8 per the instructions here: https://learn.microsoft.com/en-us/visualstudio/releases/2019/history

Unfortunately, when I re-installed the older version, integration services continues to have a "setup failed" with an unknown error. I don't know if anyone else is having this issue, but have been trying to address it for a whole day now and can't figure it out.

Are you having this issue?

Wichie Artu 6 Reputation points

2021-03-09T18:21:08.203+00:00

Finally fixed:

Went into the control panel and uninstalled EVERYTHING that said visual studio (especially application tools).

Restarted my computer

Installed version 16.8.6 (latest before 16.9) with SSDT

Installed integration services 3.12

When I opened my project it said "incompatible", but right-clicked for options, left-clicked "reload project" and FINALLY got it to work.

I can no edit my scripts no problem. Took me 2 work days to resolve. SMH...

Malta 1 Reputation point

2021-03-10T12:36:34.127+00:00

Hi,

Is there a way that I can get notified when you issue this fix? Can't work with the current VS installation, and cannot roll back because

There is no option to rollback in VS Community. The options available are for Enterprise and Professional

thus no hope for community users :(

thanks,

Wichie Artu 6 Reputation points

2021-03-10T17:52:48.687+00:00

There seems to be a community version download link within the 16.8 release notes: https://learn.microsoft.com/en-us/visualstudio/releases/2019/release-notes-v16.8

does that work?

Antonio Jose Resende de Campos 1 Reputation point

2021-03-10T19:31:50.25+00:00

I can only think of looking every day at https://developercommunity2.visualstudio.com/t/SSIS-script-task-do-not-build/1354064 for the latest comments from VS team and hope this bug gets fixed soon enough.

Malta 1 Reputation point

2021-03-11T14:02:52.307+00:00

Thanks, but despite the heading it still tried to download the latest version. Incidentally, there is a minor release as per screenshot

Bakelman, Ned L (nlb6n) 1 Reputation point

2021-04-14T04:21:08.103+00:00

I had the same issue and followed the instructions to install the VSTA fix (3.12.1). Doing install fixed the issue for me. Basically from the link provided by MyersBrennan-9988, I then clicked on the "here" link under "Common Issues" to manually install VSTA 3.12.1. After doing so, the editing script task issue went away. Thanks for providing that initial link MyersBrennan-9988 and thanks for this thread. HTH. Ned
Sign in to comment

7 additional answers

Hotbuk 6 Reputation points

2021-03-25T10:59:23.207+00:00

Upgrade of the VS2019 to 16.9.2 and repair of the SQL Server Integration Services Projects with a stand-alone installer, version 3.12.1 fixed the issue.
Please sign in to rate this answer.

1 person found this answer helpful.
Fernando Pacheco 1 Reputation point

2021-03-27T20:57:41.443+00:00

Same thing here, just reinstalled VS Community 2019 and ssis package and its now ok.
Sign in to comment
James 1 Reputation point

2021-03-09T23:07:57.99+00:00

I was also able to fix this issue by uninstalling 16.9 and installing 16.8, but got another issue then where the script tasks script button would not work.
I had to reinstall Integration Services 3.12 to get the script button to work again (running the repair install option didn't help the script button issue, it needed to be uninstalled and then installed again).
Please sign in to rate this answer.

0 comments No comments
Sign in to comment
Leandro Oliveira 1 Reputation point

2021-03-11T13:32:38.393+00:00

I have the same problem. I do not know what to do
Please sign in to rate this answer.

0 comments No comments
Sign in to comment
Bart Bertolio 1 Reputation point

2021-03-12T00:37:16.923+00:00

It is probably a regression error in VS 2018 16.9. Microsoft support pointed me to this article

https://learn.microsoft.com/en-us/answers/questions/301059/vsta-2019-unable-to-build-script-tasl.html

They said to roll back to 16.8
Please sign in to rate this answer.

0 comments No comments
Sign in to comment