A few weeks ago I was cleaning up an old server which one of my colleagues still uses for SSIS packages with Visual Studio 2008. I uninstalled VSTA 2008, because I didn't think we'd need it, but I was wrong.
Now we can't open Script Tasks anymore and I can't seem to find the setup to reinstall VSTA 2008. It doesn't seem to be included in Visual Studio 2008 either. There's only a setup for VSTOR, but I don't need that.
So the only hope I have is that somebody somewhere knows where I can get a setup of VSTA from over 10 years ago.
The VSTA (Visual Studio Tools for application) is installed with the Business Intelligence development studio 2008 which is a part of the SQL Server 2008 installation. It is not related to Visual Studio installation.
You can try to repair the SQL Server installation or to remove and reinstall the SSIS and Business Intelligence Development Studio features:
Also check the following links they contains helpful information:
After searching for a standalone installation of VSTA SDK 2.0 enu 9.0 on the Microsoft website it looks like the download link is removed and only 2012+ versions can be found.