3

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.

Hadi
  • 36,233
  • 13
  • 65
  • 124
OhSnap
  • 376
  • 2
  • 10
  • 30
  • https://meta.stackoverflow.com/questions/253521/what-can-i-do-if-i-believe-that-my-question-was-wrongly-marked-as-a-duplicate - https://meta.stackexchange.com/questions/300795/what-to-do-when-your-question-is-marked-as-duplicate-but-you-dont-see-how-so - – Yahfoufi Apr 01 '19 at 12:32
  • 2
    Please keep your language to a professional tone. – Baum mit Augen Apr 01 '19 at 12:34
  • 1
    When you install the Integration Services from SQL Server 2008 it also install SQL Server Business Intelligence Studio (Visual Studio) that contains all components needed. It it is already installed try to run a SQL Server repair installation – Yahfoufi Apr 01 '19 at 12:53
  • @BaummitAugen i think the OP is right, these question are related but there are not duplicates, i voted to reopen the question but since the sql-server tag was removed i can't reopen it immediately. Can you reopen it as a moderator? – Hadi Apr 01 '19 at 20:14
  • 2
    Reopened at request if the original Mjolnir. cc @Hadi – Baum mit Augen Apr 01 '19 at 20:27
  • @BaummitAugen thanks for the quick response – Hadi Apr 01 '19 at 20:36

1 Answers1

2

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.

Hadi
  • 36,233
  • 13
  • 65
  • 124